Mysql

Importing and Exporting data to CSV from Mysql using command line

Everyone knows you can use phpmyadmin to import and export data to and from Mysql. I needed to be able to do this programaitcally and fast. I use Drupal so could have written a module to read the data from the table and then write out to a file line by line, this would be slow and my tables are large. So I found this method which is native MYSQL and is really efficent.

Syndicate content