I've created a MySQL DB and various tables. For a particular table I am trying to avoid typing in literally 2,000 entries so I've created a .txt file that is properly deliminated, etc.
In phpMyAdmin, there is an option "Insert textfiles into table" which I am trying to use to upload this .txt file into the table. Using this feature the first option is to select the location of the actual .txt file - a browse button is provided to this end.
When I select the .txt file via this option I get the following error when I process the request:
"...File '/tmp/phplz8BIW' not found (Errcode: 0)"
It almost seems like it finds the file on my local drive, but then can't associate it when it is placed into a tmp dir on the server.
Any help would be greatly appreciated!
jpipes