List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:May 7 2002 11:46am
Subject:Re: Converting text files to MySQL
View as plain text  
Christy,
Monday, May 06, 2002, 8:56:53 PM, you wrote:

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

Christy, give me some more info:
1. What OS are your using?
2. What MySQL server are you using (version, binary or source
distribution etc.)?
3. What is your client software?

CR> Christy Roberts





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com


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