My bad, bad mistake

  • -jc

    (@-jc)


    16 years, 1 month ago

    While attempting to do some database maintenance, I accidentally deleted the entire comments table. And no, I don’t have any backups; I was getting ready to do my first when I clicked on the wrong thing. I don’t care about losing the past comments; they were 99% spam anyway. But I now have error messages on most of my pages, because WordPress can’t find “wp-comments”.

    Any advice, short of doing a complete re-install? If I do have to reinstall, how can avoid overwriting everything I’ve already done? Any good suggestions, would be very much appreciated. Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Khairil Zhafri

    (@poppacket)

    16 years, 1 month ago

    Just install a fresh WordPress with a different table prefix/database in wp-config.php. Then just copy what you have lost in the original database from the new table/database. Change back what you’ve changed in wp-config.php.

    Good luck 🙂

    Thread Starter -jc

    (@-jc)

    16 years, 1 month ago

    Got it. Thanks very much. I’ll give it a whirl.

    jonimueller

    (@jonimueller)

    16 years, 1 month ago

    that’s overkill. Just create a new database TABLE OR run the upgrade.php script again, shouldn’t hurt anything. It should repopulate the missing database table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘My bad, bad mistake’ is closed to new replies.