so that it only backups the given tables. mysqldump -u -p yourdb yourtable > c:\backups\backup.sql

Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql