Restoring Single Table

To restore a single item such as a table, you currently need to restore the dump file to a directory and use the mysql command.

$ sed -n -e '/Table structure for table .mytable.$/,/Table structure for table/p' data.sql

The above sed command will extract the table structure, the index and the data from the dump.

See also

Previous articles:

• Restoring Users and Roles

• Restoring Single Database

• Restoring Dump Files To Directory

• PITR Using Binary Logs

Next articles:

• Restoring Complete Server

• Restoring Using MySQL Command-Line Tool

Go back to: Restoring Using Dumps.