Sites lost after DB Backup

  • Hi,

    After a big issue on my site I restored it with a DB Backup. It’s weird but I have now the DB tables dupplicated and :

    1) I don’t know which one is used by the current site
    2) When trying to add a missing site, I got an error message : “This site already exist”. How to display it within “My Sites > Missing_Site” ?
    3) How to identify the missing site in the DB?

    Cheers

Viewing 1 replies (of 1 total)
  • Moderator Bet Hannon

    (@bethannon1)

    If you still have the backup to restore from, in PHPMyAdmin you could backup the current duplicated database, then delete (drop) ALL the current tables, and then import the backup.

    If that won’t work out, then check to see if the duplicated tables have the same prefix on them. The default is wp_, but your’s might be something else. Maybe the restored tables have a different prefix?

    If it’s different, you’ll be able to tell which your network is using by looking at the prefix setting in wp-config.php.

    If the prefixes are the same, that’s not good, and you’ll need to do something like my initial suggestion.

    2 & 3) I think your already existing site issue will clear up when you fix the db tables duplication.

Viewing 1 replies (of 1 total)
  • The topic ‘Sites lost after DB Backup’ is closed to new replies.

Tags