Backup and Restore a Single Table with mysqldump

Uncategorized — Titus Barik on February 2, 2010 at 5:09 pm

It is sometimes useful to backup a single table from a MySQL database and re-load it on a different database. You can do so with the following operations:

To backup:

mysqldump original_db table_name > table.sql

To restore:

mysql new_db < table.sql

0 Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

titus@barik.net | The Weblog of Titus Barik