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

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.