Thursday, February 18, 2010

mysql dump and restore a single table.

SkyHi @ Thursday, February 18, 2010
Dumping or backing up a table:

mysqldump -u username -ppassword --default-character-set = latin1 --single-transaction database --tables table > /location/table_bk.sql


Restoring a backed up sql(append table_bk to exsting database) ---Proof to work

mysql -u username -ppassword database < /location/table_bk.sql

REFERENCE
http://mylinuxwiki.blogspot.com/2008/10/mysql-dump-and-restore-single-table.html