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

Go back to:

• Restoring Users and Roles

• Restoring Single Database

• Restoring Dump Files To Directory

• PITR Using Binary Logs

Go to:

• Restoring Complete Server

• Restoring Using MySQL Command-Line Tool

Go back to the Restoring Using Dumps page.

Go back to the Restore page.

Go back to the main Operations page.