By default, mysqldump
takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?
Mysql – How to take backup of a single table in a MySQL database
backupMySQLrestore
Related Topic
- Sql-server – SQL Server: Database stuck in “Restoring” state
- Mysql – How to specify unique constraint for multiple columns in MySQL
- Mysql – restore a single table from a full thesql thesqldump file
- Mysql – How to see what character set a MySQL database / table / column is
- Mysql – How to get a list of user accounts using the command line in MySQL
- Mysql – How to get size of thesql database
- Mysql – Duplicating a MySQL table, indices, and data
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
Dump and restore a single table from .sql
Dump
Dumping from a remote database
For further reference:
http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html
Restore
or in one line
mysql -u username -p db_name < /path/to/table_name.sql
Dump and restore a single table from a compressed (.sql.gz) format
Credit: John McGrath
Dump
Restore