List:General Discussion« Previous MessageNext Message »
From:Christy Roberts Date:May 6 2002 5:56pm
Subject:Converting text files to MySQL
View as plain text  
I've been trying to import text files into MySQL, but I can't get it to
work.  I'm new to MySQL and am still getting familiar with it, so
perhaps I'm missing something.  I'm using the LOAD DATA LOCAL command
but I keep getting error 1148 "The used command is not allowed with this
MySQL version."  Now from reading  the information in the docs section
(http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD
DATA LOCAL is sometimes disabled for security reasons, and that there
are two ways around this.  I've tried both ways but it doesn't seem to
work.  I tried using the command --enable-local-infile but apparently
that's only compatible with version 3.23.48 and before, and we have
3.23.49.  Is there something else I should do?  Can anyone help me
please?  Thanks so much!

Christy Roberts
Technical Project Lead
iMIRADOR.com Inc.
St. John's, Newfoundland
Tel: 709.737.4485
 
 


Thread
Converting text files to MySQLChristy Roberts6 May
  • Re: Converting text files to MySQLEgor Egorov7 May
    • RE: Converting text files to MySQLChristy Roberts7 May
      • Re: RE: Converting text files to MySQLEgor Egorov7 May
        • RE: RE: Converting text files to MySQLChristy Roberts7 May
          • RE: RE: Converting text files to MySQLGurhan Ozen7 May
            • RE: RE: Converting text files to MySQLChristy Roberts7 May
              • RE: RE: Converting text files to MySQLGurhan Ozen7 May
                • RE: RE: Converting text files to MySQLChristy Roberts7 May
                  • Re: RE: Converting text files to MySQLMatthew K. Gold7 May
          • Re: RE: RE: Converting text files to MySQLEgor Egorov8 May
            • RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
              • Re: RE: RE: RE: Converting text files to MySQLEgor Egorov8 May
                • RE: RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
                • RE: RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
                  • Re: RE: RE: RE: RE: Converting text files to MySQLEgor Egorov9 May
Re: Converting text files to MySQLTerrence Cox7 May