Steve Buehler <[EMAIL PROTECTED]> wrote:
> I have upgraded my mysql version to 3.23.58 and am coming up with a couple
> of errors using phpmyadmin to "Insert data from a textfile into table" I
> didn't get this on the previous versions of mysql. Here are the errors:
>
> SQL-query :
>
> LOAD DATA INFILE '/tmp/phpKFlQ2b' INTO TABLE `annsubscribers` FIELDS
> TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
> `email`
> )
>
> MySQL said:
>
> #1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
User must have FILE privilege to use LOAD DATA INFILE.
>
> ---------------
>
> SQL-query :
>
> LOAD DATA LOCAL INFILE '/tmp/phpsj1WGM' INTO TABLE `annsubscribers` FIELDS
> TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
> `email`
> )
>
> MySQL said:
>
> #1148 - The used command is not allowed with this MySQL version
You should run server and client with --local-infile option:
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
>
> ---------------
> Can anybody shed some light on how to fix this? I presume the first is a
> permission problem that is from the new way that MySQL handles things. The
> second is just a mystery to me.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
