How Do I Backup and Restore a Single MySQL Table?

Backup and Restore of a Single MySQL Table

By default, the mysqldump utility backs up the entire database. However, it may be necessary to selectively backup a single table.

How to Backup a Single Table:

Exporting the table data to an .sql file:

mysqldump db_name table_name > table_name.sql

Exporting from a remote database:

mysqldump -u db_username -h db_host -p db_name table_name > table_name.sql

Restoring a Single Table:

Using a .sql file:

mysql -u username -p db_name
mysql> source full_path/table_name.sql

Alternatively:

mysql -u username -p db_name <p><strong>Restoring from a compressed .sql.gz file:</strong></p><p><strong>Dumping the data:</strong></p><pre class="brush:php;toolbar:false">mysqldump db_name table_name | gzip > table_name.sql.gz

Restoring the data:

gunzip 

The above is the detailed content of How Do I Backup and Restore a Single MySQL Table?. For more information, please follow other related articles on the PHP Chinese website!