Thursday, October 23, 2008

mysql dump and restore a single table.

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.

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

No comments:

 
Custom Search