Reinstalled WP, Lost Some Tables

  • Hi,

    I recently had to delete my WordPress blog, install a new copy, and migrate over the database from a backup.

    When I first tried to bring my blog up, I got a lot of error messages about wpdk_* tables being missing. These:

    wpdk_blog_versions
    wpdk_blogs
    wpdk_commentmeta
    wpdk_comments
    wpdk_links
    wpdk_options
    wpdk_postmeta
    wpdk_posts
    wpdk_registration_log
    wpdk_signups
    wpdk_site
    wpdk_sitemeta
    wpdk_term_relationships
    wpdk_term_taxonomy
    wpdk_termmeta
    wpdk_terms
    wpdk_usermeta
    wpdk_users

    I checked my database backup ( a *.SQL file ) and these tables were not included in it.

    The wp_* versions of those tables do exist.

    I replaced the wpdk tables with near blank copies from a fresh WP database.

    I got my blog up, but it looks like all my posts and pages are missing.

    I don’t think they actually are missing. For example wp_posts, wp_comments exist and are healthily populated.

    I’m guessing the wpdk_* tables are some kind of meta tables that need to be synchronized with the rest of the data.

    So…, my question is, how do I get all of my old data, the posts, pages, and comments to appear on my blog again?

    Thanks much

    Steve

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)

  • Looks like only the database prefix was changed. If you change wpdk_ to wp_ in your backup and import the database you should be fine, but no warranties by me!

    Thread Starter crankyvegan

    (@crankyvegan)

    To be clear,

    There should not be wpdk_ and wp_ tables with the same name after underscore?

    Thanks

    Steve

    I can only guess, but wp_ is the standard prefix and wpdk_ doesn’t look like any popular prefix of.. anything, but to me it looks like the prefix has been changed in wp_config of your site where the database was and is now your backup. So if you change that (back) to wp_ it should result in a working copy of your site, while not havin the wpdk_ tables anymore.

    edit: reading it again could be the other way around, however, make sure in your wp_config file the prefix meets the one of the database

    • This reply was modified 6 years, 11 months ago by Presskopp.
    Thread Starter crankyvegan

    (@crankyvegan)

    I’m going to play it safe and copy the records from old to new.

    I was at it for several hours today getting as far as I got.

    I will try it out tomorrow when I am less frazzled.

    Thanks for the idea!

    Steve

    Thread Starter crankyvegan

    (@crankyvegan)

    Thank you that was the case.

    I overwrote the wpdk_* version of the tables ( most of them near blank ) with the copies of the similarly named wp_* tables from my backups.

    I got all of my posts and comments back.

    Thank You.

    Steve

    @crankyvegan

    Please forgive my ignorance… I have looked for hours through various forums without finding the answer to how exactly do you replace selected tables from a DB backup?In my case the hosting DB server went down for 5 min and various tables are now missing/deleted, but I dont want to restore the entire DB from a backup!

    Thanks for the tips.

    Thread Starter crankyvegan

    (@crankyvegan)

    Hi gastronimo,

    I think you can create a new database in phpMyAdmin and import your datababase back up into it.

    Then you can go to the export tab in phpMyAdmin, and export a single “backup” table into a SQL file.

    Then you can go into your main database, go to the import tab of phpMyAdmin, choose your backedUpTale.sql, click on the advanced options, choose “drop table” ( if it is there, to clear the table if it is empty ), then “go”. You will end up importing just that table.

    Repeat for the few tables you do want to restore.

    Tip:

    If you are importing a table that does not exist, make sure the name of the receiving database is highlighted.

    If you are exporting a single table, make sure the name of the table is highlighted before you go to the export tab.

    • This reply was modified 6 years, 10 months ago by crankyvegan.
    • This reply was modified 6 years, 10 months ago by crankyvegan.

    That is fantastic, than you a billion!

    Thread Starter crankyvegan

    (@crankyvegan)

    I take it that it worked and all is well now?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Reinstalled WP, Lost Some Tables’ is closed to new replies.