Free script to import csv data into mysql

legend2 · 02-24-2007, 02:03 PM

Some people have the database data in a a coma separated value format and would like to import that into their database.
You can use this script http://www.legend.ws/blog/tips-trick...-mysql-import/

If your data is still in excel format, save it as csv.
Read more about it in the link.

Or you can do it simply with a single command from the prompt http://www.legend.ws/blog/tips-trick...-mysql-prompt/

PS: these are useful if you do not have phpmyadmin.

Good luck.

Dan · 02-24-2007, 11:01 PM

I suggest installing phpMyAdmin if you don't have it..

02-24-2007, 02:03 PM	#1 (permalink)
legend2 Senior Member Join Date: Sep 2005 Posts: 1,102 141.05 NP$ (Donate)	Free script to import csv data into mysql Some people have the database data in a a coma separated value format and would like to import that into their database. You can use this script http://www.legend.ws/blog/tips-trick...-mysql-import/ If your data is still in excel format, save it as csv. Read more about it in the link. Or you can do it simply with a single command from the prompt http://www.legend.ws/blog/tips-trick...-mysql-prompt/ PS: these are useful if you do not have phpmyadmin. Good luck.

02-24-2007, 11:01 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	I suggest installing phpMyAdmin if you don't have it..

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)