Lost it

  • zukester

    (@zukester)


    16 years, 1 month ago

    Hi:

    Had WordPress running for some time, and it went kablooey. Just a blank white page with nearly no html (upon view source).

    Talked to Hostgator. They said “some themes bring it down”. I know I was messing with the themes a while back, but it worked long after that.

    1. Reinstalled WordPress
    2. Trying to reconnect to DB to retrieve files via wp-config.php.
    3. Does not allow me to change without an error.
    4. deleted old one and reinstalled it to same named directory
    5. Reinstalled into DIFFERENT directory.

    Forget the themes….how do I at least restore the posts? I can see the db there in MySQL in the Hostgator control panel, but no matter what I try, nothing.

    Thanks,

    Zukester

Viewing 5 replies - 1 through 5 (of 5 total)
  • esmi

    (@esmi)

    16 years, 1 month ago

    Do you have a database backup that was made before the site went down? The problem could be in your database.

    Thread Starter zukester

    (@zukester)

    16 years, 1 month ago

    I have a backup, yes. How do they become corrupt and how do I fix it, then prevent it from happening?

    Thanks,
    zukester

    esmi

    (@esmi)

    16 years, 1 month ago

    There are all kinds of issues that could damage a database. The server could collapse in the middle of a database write. An incompatible plugin could attempt to write to the database and fail – badly. Ditto for a theme in theory. Remember that a database is just an indexed collection of bits of electronic data and that any stored data is fragile at the best of times.

    PhpMyAdmin has a Repair function that you can run on individual database tables but it’s a limited tool and it will not be able to fix all errors. This is why regular database backups are essential.

    Thread Starter zukester

    (@zukester)

    16 years, 1 month ago

    Ah, OK. Then this is better news. I did a backup to a zipped file which I stored on the site and locally. I can unpack it and redo the DB again, I guess. Worst case anyways.

    So ,elt me try this PhpMyAdmin tool first and, failing that, I can try to restore the CB. Failing that, I will do a backup after each several posts or even semi-weekly.

    Will let you know what happens.

    Thanks so much. Excellent forum, and I am on a lot of forums, from photography to geek stuff.

    esmi

    (@esmi)

    16 years, 1 month ago

    I’d suggest creating a new database and importing your backup into there. Then amending your wp-config.php file to point to the new db. That way, you’re not over-writing anything and there’s less risk of you retaining an db error.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Lost it’ is closed to new replies.