How do you Import .CSV file into your Yahoo Web Hosting MySQL Database?

Question

I have a table with 17 fields and data that I inserted 1 by 1 for testing. I exported that data via the phpmyadmin export tab and exported it as a CSV for Excel with fields names in the first row. I then deleted the data (not the structure) from the table. I then deleted the data (not the structure) and went to import the same exact file I exported but could not import it no matter what I did.

I uploaded the data.csv exported file to my main directory and used the following SQL statement but it didn't import:

LOAD DATA LOCAL INFILE 'data.csv'
INTO TABLE data
FIELDS TERMINATED BY ','
LINES TERMINATED BY "\r\n";

I used to import my data using the "Insert data from a text file into the table" located under the Import Tab but it doesn't function as it used to.

Can anyone advise the best way to import my data?

Yahoo uses phpMyAdmin 2.6.3-pl1 and MySQL 4.1.14.

Thanks.

Answer 1

The best way is to pull out your localhost data into 'data.sql' or something. you can do that by using mysql. after that, create a database in yahoo and import your data in.

hope works well...
herdinata sinuhaji
http://thesamura.blogspot.com

Answer 2

there's a freeware project observed as phpMyAdmin which makes database maintenance a good purchase greater potential with an internet site-based gui. i might seem into that till now attempting to debug Hypertext Preprocessor code written for another .csv data.