I just tried phpMyAdmin > Import and the only option it offered me was "SQL" formatted file. If you can't find a way to directly import a CSV file, you have two options:
1) If it's a "one off" job, manually (or with a script) turn your CSV file into a .sql file with the data formatted into an INSERT statement:
INSERT INTO tablename (field1, field2, field3,...) VALUES
('data1-1', 'data1-2', 'data1-3',...)
,('data2-1', 'data2-2', 'data2-3',...)
etc. That can be IMPORTed into phpMyAdmin. Do up to 100 records at a time.
2) If it's something that's going to be done repeatedly, write a PHP script to read in the CSV file and build an SQL query that looks like the above:
mysql_connect(....);
mysql_selectdb(....);
$count = 0;
while(true) {
if ($count==0) $query = 'INSERT INTO tablename (field1, field2, field3,...) VALUES';
if ($count>0) $query .= ',';
$count++;
... read in one row
if (eof on input) {
if ($count>1) mysql_query($query); // might do error checking here
break;
}
$query .= "('" . $data1 . "','" . $data2..... "')";
if ($count==100) {
mysql_query($query); // might do error checking here
$count = 0;
}
}
Or something close to that. Obviously, at a minimum you want to give an obscure name to the script so that hackers can't stumble across it and mess up your database.
