WordPress.org

Ready to get started?Download WordPress

Forums

My bad, bad mistake (4 posts)

  1. -JC
    Member
    Posted 6 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.

  2. Khairil Zhafri
    Member
    Posted 6 years 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 :)

  3. -JC
    Member
    Posted 6 years ago #

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

  4. Joni
    Member
    Posted 6 years 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.

Topic Closed

This topic has been closed to new replies.

About this Topic