Dumping a mysql table to SQL
I usually use phpMyAdmin to dump my table to SQL, but sometimes it is easier to do it from the command line. Use the following syntax to dump a table to SQL.
mysqldump -p -e -c --add-drop-table -r table.sql dbname table
Warning: The –add-drop-table will cause it to drop the existing table when you import.
You can import this with the command
mysql -p dbname < table.sql
Trylinux.org