In a certain database, there are may just some main tables which controls everything in your application and contain all your main contents which are updated daily by your staff or your members.
When you want to backup or get the content in SQL or CSV format of a particular table in your database, you don’t need to backup the whole database. It may waste your time/resources and the process will take more time to finish.
In this tutorial, I’ll show How to backup and restore a single table using MySQLDump:
1. Backing up a single table from a database:
mysqldump -u db_user -p database_one TABLE_NAME < /var/www/backups/TABLE_NAME.sql |
2. Restoring the table into another database:
mysql -u db_user -p database_two < /var/www/backups/TABLE_NAME.sql |
With UTF-8: , try this:
mysql -u db_user -p --default-character-set=utf8 database_two < /var/www/backups/table_name.sql |