Import three specific tables from a DB backup after plugin fail

  • Resolved volker.zimmermann

    (@volkerzimmermann)


    12 years, 10 months ago

    I have had a problem with a plugin (WP download codes) after moving my wordpress site to a new server. I did not get the plugin to work correctly, so I deleted and reinstalled it hoping that this would fix the problem (stupid move). Now the plugin is back up and running again, but I’m missing the data (Download codes already provided to customers), which I have in the form of a Backup of my database.

    My question is, how do I just import the three tables I need from the backup into my database, using phpmyadmin?

    Alternatively, I could make a backup of the current database and feed in the needed data from the backup, but I’m not sure how to go about this, or if it is unnecessarily complicated.

    Any help would be greatly appreciated!

Viewing 1 replies (of 1 total)
  • Thread Starter volker.zimmermann

    (@volkerzimmermann)

    12 years, 10 months ago

    Found a solution – I don’t know if this is recommended, but I simply opened both SQL files in Textmate, and was able to identify the tables that I needed to copy over. I simply copy&pasted the stuff that I needed into the backed up current table, then dropped all my tables in the live database, and re-imported the backup with the new data added.

    Everything worked!

Viewing 1 replies (of 1 total)
  • The topic ‘Import three specific tables from a DB backup after plugin fail’ is closed to new replies.