MySQL DBA - Tips and Techniques Magazine

11 Nov 2014

Backing up / Restoring a single table from a database

Useful if transferring tables between databases / servers

Backup table on 1st database / server

            mysqldump –u<user> -p<password> database_one table_name > /tmp/table_name.sql

Restoring the table into another database

            mysql –u<user> -p<password> database_two < /tmp/table_name.sql

No comments:

Post a comment