Snippets

Backuping and restoring a single table using mysqldump

Backuping a single table from a database
mysqldump -u -p database_one table_name > /var/www/backups/table_name.sql

Restoring the table into another database
mysql -u -p database_two < /var/www/backups/table_name.sql

For more Linux commands, please refer to:

8 thoughts on “Backuping and restoring a single table using mysqldump

Comments are closed.

Career Guide for Software Developers