Home › Forums › Webmastery › PHP Scripting ›

MySQL Imports?

cdiamond's picture
Submitted by cdiamond on Sun, 12/17/2006 - 20:31.

I used to be SQL Server dba, so switching to MySQL has been a bit of a learning experience...does MySQL have a data import feature like SQL Server does? I can run a DTS Import to grab data easily and transform it in SQL server, but I"m not finding a good way to do the same thing in MySQL. Althoug the NaviCat tool that Jeremy posted in this forum looks like it might have that feature.

Thanks,

Chris

‹ PHPMyAdmin My Tracking Cookies in Wordpress ›
Jeremy Palmer's picture
Submitted by Jeremy Palmer on Sun, 12/17/2006 - 21:32.

Both PHPMyAdmin and Navicat have an import feature. However, Navicat can handle larger imports.

MySQL has built-in import features too, but requires more work:
http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

Best,

Jeremy

Syndicate content