Title: Import ONE table from a complete database EXPORT using PhpMyAdmin
Last modified: August 30, 2016

---

# Import ONE table from a complete database EXPORT using PhpMyAdmin

 *  Resolved [AndieB](https://wordpress.org/support/users/andieb/)
 * (@andieb)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/import-one-table-from-a-complete-database-export-using-phpmyadmin/)
 * Hi,
 * I made a complete backup of my database using PhpMyAdmin.
    Upgraded to WordPress
   4.4 which worked fine. Upgraded a couple of plugins and then one of them failed.
 * Now I do not want to import my whole database from the full dump, but only ONE
   table that is missing.
 * Is this possible to accomplish?
 * Thank you!

Viewing 1 replies (of 1 total)

 *  [Gary Pendergast](https://wordpress.org/support/users/pento/)
 * (@pento)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/import-one-table-from-a-complete-database-export-using-phpmyadmin/#post-6846266)
 * Hi [@andieb](https://wordpress.org/support/users/andieb/)!
 * phpMyAdmin doesn’t have the ability to import a single table from a dump file
   for a whole database. Instead, you need to extract the table data from the dump
   file.
 * If you’re comfortable on the Linux or OSX command line, you can use this command
   to extract the table:
 * `sed -n -e '/CREATE TABLE.*mytable/,/CREATE TABLE/p' mysql.dump > mytable.dump`
 * Substitute `mytable` for the actual table name.
 * If that’s not an option, you can open the dump file in your preferred text editor,
   and copy everything from the `CREATE TABLE` statement for the table you’re after,
   up to the line before the next `CREATE TABLE` statement in the file.

Viewing 1 replies (of 1 total)

The topic ‘Import ONE table from a complete database EXPORT using PhpMyAdmin’ is
closed to new replies.

## Tags

 * [full](https://wordpress.org/support/topic-tag/full/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Gary Pendergast](https://wordpress.org/support/users/pento/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/import-one-table-from-a-complete-database-export-using-phpmyadmin/#post-6846266)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics