Posted by Dano on 09/23/06 12:24

Pretty easy to do with CSV and PHPMyAdmin.

If your file is in CSV, just go to the "Import" tab in PHPMyAdmin. It's
pretty standard across different PHPMyAdmin versions.

There, just browse for the file location, check the appropriate boxes,
and click "Go." Depending on your connection speed, it could take a
while. I used to load an 84-column, 12,000-row CSV file over a DSL
connection, and it would usually take 30-40 minutes, on average.

Hope that helps!

halbenca@gmail.com wrote:
> I have a CSV file with 5 columns and about 20000 lines. Is there a
> simple utility out there that will convert this file into a conforming
> text file I can then proceed to import into my database via Web
> interface phpMyAdmin? These are the confines I have to work within as
> I have to import it from the Web access of phpMyAdmin, any solutions or
> ideas? BEST REGARDS, Danny

[Back to original message]