|
|
Posted by Erwin Moller on 06/07/06 10:21
Justin wrote:
> Hi, im facing a problem here. First of all here is my program
> requirement. I got a .csv file with thousands of records inside, i need
> to import them into my mysql database. So i tried using load data
> infile on my pc using localhost everything goes fine, but when i change
> the connection to my server, it seems tat the connection cant be
> done... so wat went wrong?
Hi,
I guess LOAD DATA INFILE is a mysql command that loads data from a file into
the db, right?
If that is working on server1 and not on server2, I guess server2 uses
different logincredentials (different username or password).
OR you have a problem with readpermissions.
Can the mySQL user READ the .csv file?
*nix
chmod the csv file to 777 if this a one time action.
If you need to do this a lot, set the ReadWriteExecute to the csv file to a
more appropriate (restricted) level.
W$
Get the properties->security and make sure the file can be read by the
process that runs mysql.
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|