Import ONE table from a complete database EXPORT using PhpMyAdmin

  • Resolved AndieB

    (@andieb)


    9 years, 3 months ago

    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)

  • Hi @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.