Restore a single table from a full mysqldump file

Note: This article assumes that you have installed and configured MySQL® on your server.

Prerequisites

• A MySQL® server
• Access to a MySQL® privileged user such as root.
• A MySQL® dump file of the database that includes the table that you want to import.

Procedure

1. Login into your MySQL® server.
   Note: This step can change depending on your OS and user type.
   Shell

   mysql -u root -p
   

2. Create a temporary database.
   MySQL

   CREATE DATABASE tempdatabase;
   

3. Exit the MySQL® server.
   MySQL

   exit;
   

4. Go to the MySQL® dump file directory and execute the following command:
   Shell

   mysql -u root -p tempdatabase < mysqldump.sql
   

5. Login into your MySQL® server to ensure that your database was imported properly and the table exists. (Optional)
   Login into your MySQL® server.
   Shell

   mysql -u root -p
   

   Switch to the temporary database and show the tables:
   MySQL

   USE tempdatabase;
   SHOW TABLES;
   exit;
   

6. Export the desire table to a MySQL® dump.
   Shell

   mysqldump -u root -p tempdatabase mytable > mytabledump.sql
   

7. Import the table to the database.
   Shell

   mysql -u root -p mydatabase < mytabledump.sql
   

8. Delete the temporary database.
   Login into your MySQL® server.
   Shell

   mysql -u root -p
   

   Delete the database:
   MySQL

   DROP DATABASE tempdatabase;
   exit;