MySQL

Backup and Restore Table to MySQL Database

Taking backup

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

restoring from backup file need not include table name


# mysql -u -p mydatabase < table1.sql