My bad, bad mistake

  • -jc

    (@-jc)


    17 years 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)

  • 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)

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

    jonimueller

    (@jonimueller)

    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.