Backup and Restore Table to MySQL Database

October 3, 2015 by The Geek Decoder

Taking backup

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

restoring from backup file need not include table name


# mysql -u -p mydatabase < table1.sql