Need help restoring databsae

  • Resolved codyreport

    (@codyreport)


    16 years, 9 months ago

    My site, codyreport.com, went down and my host (now former host) says that the MySQL database became corrupted. Trying to restore the database with backups I made using their tools did not work. They ended up telling me that I would just have to start a new blog and that everything was lost. I change host this morning and I am trying to get my blog setup again. (The DNS information is still being updated, so you may or may not see the site.) I have a backup of my site from about a month ago on my computer. I ran a backup from running the WP database backup plugin about a month ago, also. Because the site went down, I am unable to use the export feature. Is there a way to use the files I do have to restore my blog?

Viewing 4 replies - 1 through 4 (of 4 total)
  • moshu

    (@moshu)

    16 years, 9 months ago

    In the best case scenario you would be able to restore only what is in that backup. Everything between the date of the backup and today/yesterday might be lost if your ex-host cannot recover it.

    You would need upload the same version of WP that was active at the time of the backup and then import the .sql file into the DB using phpMyadmin. I mean import it in an empty database that doesn’t have the tables. MAke sure the config file connects to the DB.

    Ask more questions if you need more help.

    Also:
    http://codex.wordpress.org/Backing_Up_Your_Database
    http://codex.wordpress.org/Backing_Up_Your_Database#Restoring_the_Data

    omgitztrey

    (@omgitztrey)

    16 years, 9 months ago

    Was the entire database corrupted or just a certain table? Would running the repair help anything?

    Thread Starter codyreport

    (@codyreport)

    16 years, 9 months ago

    moshu,
    Thanks! Those links you provided really helped. I was able to get all of my content back (up until the last backup at least) and most of the formating. Something strange is going on with my sidebar, but I’ll fix that another day. I am just glad to have saved the post and comments.

    omgitztrey,
    The previous host couldn’t tell me anything. Repair, a backup restore and even rolling back the entire site to a point when it was working didn’t help. They were pretty rude about the whole thing and made it clear that they weren’t going to help with a MySQL issue. I’ve since changed host.

    Thanks for taking the time out to help me guys.

    Rok

    (@rok)

    16 years, 9 months ago

    1. Ask your Host, if they have seperate MySQL Server, if yes, you can still login to your MySQL account.
    2. Once there, instead of exporting whole WordPress DB, just export single table at a time.
    3. There after, check which table has got corrputed, and use repair option.

    Else, follow Moshu’s reply, ‘coz you’ve no current backup.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Need help restoring databsae’ is closed to new replies.