Taking a backup of a MySQL table and restoring it

Use the command below to take a backup of only one table:

# mysqldump -u db_username -p mydatabase table1 > table1.sql

Use the command below to restore the table:

#mysql -u db_username -p mydatabase < table1.sql

]]>