UPLOAD FILE into MYSQL using phpMyadmin, file not read

Posted: Fri Jul 09, 2004 11:55 pm (20 years, 5 months ago)

Ok. I've set the upload directory in the config.ini file, i've exported an excel sheet as a .csv file and when I goto upload it, the response I receive is:

File could not be read /usr/local/apache/htdocs/******/*****/test.csv

Why is this happening? I am really new to this and trying to get a lot of data in my tables and really want this to work.

Any advice?

BTW-I am connecting to mySQL through my ISP who claims there are not restrictions on my account. I've had no problems setting up tables or inserting data thus far.

Junior WebHelper Joined: 04 Aug 2004 Posts: 5

I had the same problem, it's something to do with the line breaks that Excel puts in. They are not compatible with MySql which interprets the file as one long line.
After much experimentation and no results I bought a converter from the place below. At $30, it's saved me from death by frustration.
http://www.convert-in.com/xls2sql.htm
I'm sure there are free ones out there, it's just I needed to get my stuff sorted out fairly quickly.
Cheers, Frank.

Junior WebHelper Joined: 04 Aug 2004 Posts: 5

Well I do feel a bit of a pillock, and $30 poorer.
I've now discovered I didn't need that program anyway.
I was trying to run an SQL Query, which may eventually have worked but was a very silly way of going about it.

The method below works and has already been explained by the moderators.
This is just in case anybody else is tempted to shell out $30 unnecessarily on the strength of my earlier post.

In phpMyAdmin:
1. Set up the table with the field names
2. Select the SQL tab
3. Click on <Insert data from a text file>
4. Browse to the location of the csv file
5. Change 'Fields terminated by' from <;> to <,>
6. Click <Submit>
7. Sorted! The data goes in no problem.
A classic case of 'Engage brain before opening mouth'. I shall be more careful in future.