Menu
▾
▴
#835 Importing with 2.5.0-rc2 or 2.4.0
2.3.3pl1 is one of the few versions I can still import with.
I receive the following mySQL error message when importing anything
using the command "Insert data from a textfile into table". If you can't
reproduce this, please let me know and perhaps I'll try other versions
as well... or any other suggestions.
======================
Error
SQL-query :
LOAD DATA INFILE '/tmp/phpTHYoIT' INTO TABLE
`test_table` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\\' LINES TERMINATED BY '\n'
MySQL said:
Access denied for user: 'user_name@localhost' (Using password:
YES)
Back
Logged In: YES
user_id=210714
With recent phpMyAdmin, you need FILE global privilege to be
able to use LOAD DATA INFILE.
With older versions we were using LOAD DATA LOCAL INFILE.
Logged In: YES
user_id=473563
As I didn't follow that whole issue - couldn't we offer some
support to optionally use "DATA LOCAL INFILE" instead of
"DATA INFILE"?
Regards,
Garvin.