Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u -p db_name mysql> source /table_name.sql or in one line mysql -u username -p db_name table_name.sq

Backup and Restore Mysql database table

May 29, 2014February 11, 2017 eduguru 0 Comments Backup and Restore Mysql database table, Backup and Restore MySQL Database Using mysqldump, Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u -p db_name mysql> source /table_name.sql or in one line mysql -u username -p db_name table_name.sq, How to Back Up and Restore a MySQL Database, 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