Software

Ask something
Question Locked

mysql load data local infile

0 helpful
2 replies

by georgeh536

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Real basic: Can't load a csv into an existing but empty database. Coming back to mysql after extended absence. Used to do this all the time in ver 4. now ver 5. error message says mysql can't find the file (which I have put copies of all over the place and have pasted a copy of the patch into the command line surrounded by quotes, etc. This is a stand-alone, learning instance, no network involved. I suspect I may have set up improperly via a vis security. Not much in it yet so reinstalling from scratch properly is an available option.

2 replies

by tony hopkinson

Bit rusty myslef, but there's a specific permission to load data from a file, also the file itself has to be accessible to the account the DBMS is running at.

PS you know if you have replication on, all the servers in the replication group have to be able see file.

This discussion is closed to new replies.