There may come a time when you need to back up a table in MySQL and restore it to another table. Perhaps you are consolidating data from several tables into one, or you are restoring a table that has been damaged. Whatever the reason, the process of backing up and restoring a table in MySQL is not difficult.
To back up a table in MySQL, use the following command:
mysqlBACKUP TABLE table_name TO OUTFILE ‘file_name’
This command will create …