3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

Deleting the Wordpress MySQL Database

by Jet
2 replies
  • WEB DESIGN
    • |
I have a WP blog and I think something in the MySQL DB is corrupted.

Is there a way to delete the whole DB and rebuild but yet maintain the posts and pages which I have created so far?

JH
#database #deleting #mysql #wordpress
  • Profile picture of the author mywebwork
    You could delete the database and create a new one and use your most recent good backup (one made before the corruption occurred) to populate it.

    If you want to try and repair it instead WordPress now has a feature to do this. You add the statement define('WP_ALLOW_REPAIR', true); to your wp-config.php file and follow the instructions.

    You can also try repairing it manually, a good article is here WordPress Repairing mySQL tables

    Personally I'd just use the backup, unless you really have made a lot of changes since you did your last one. But if you have then you probably aren't backing up frequently enough!

    Best of luck with it.

    Bill
    {{ DiscussionBoard.errors[2809054].message }}
  • Profile picture of the author Jet
    You're right, I haven't backed up at all.

    So I guess I'll have to try another way.
    Signature
    Play Treasure Hunt For an Income - Away From Internet Marketing
    {{ DiscussionBoard.errors[2809460].message }}

Trending Topics