Backup and Restore a Single Table with mysqldump
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