Jun 30th, 2015 at 12:03 PM

Dump and restore a single table from MySQL

Dumping from a localhost database

Dump: mysqldump -u <db_username> -p db_name table_name > table_name.sql Restore: mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or mysql> databasename tableName < path/example.sql

Dumping from a remote database

Dump: mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql Restore: mysql -u <user_name> -h <db_host> -p db_name mysql> source <full_path>/table_name.sql

Dump and restore a single table from a compressed (.sql.gz) format

Dump: mysqldump db_name table_name | gzip > table_name.sql.gz Restore: gunzip < table_name.sql.gz | mysql -u username -p db_name