Help, I suddenly lost my WordPress blog!

Discussion in 'MySQL' started by Zhu, Jun 28, 2008.

  1. #1
    Ooops...

    I'm not sure what is going on, but one minute, my self-hosted WordPress blog was fine and I was replying to comments, and the next minute, I had this splash screen:

    My hosting company is Site5. I logged into my SiteAdmin to check Site5's current server status, but everything is "up" according to them.

    Now I'm lost. I haven't changed anything on my blog since I set it up a year ago and I really don't know what's going on!

    The only things I can think off:

    1) I changed my WordPress login password about two months ago.
    2) My wp-config file:

    // ** MySQL settings ** //
    define('DB_NAME', 'correres_wrdp1'); // The name of the database
    define('DB_USER', 'correres_Xiaozhu'); // Your MySQL username
    define('DB_PASSWORD', '***********'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    Some help would be appreciated! I'm pretty stressed out... :eek:
     
    Zhu, Jun 28, 2008 IP
  2. David Pankhurst

    David Pankhurst Member

    Messages:
    39
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    I once had a site get 'restored' by my hosting company - they garbled a few files, and so my blog was down - check that your wp-config.php on your site IS currently set right, and all entries make sense.

    After than, check into their site and confirm they haven't done anything unusual, like changing the localhost name, or moved servers.

    Finally, refresh your site. If someone else sharing your hosting is accessing the database a lot, then your site may not be able to connect - everything works, but it's fighting against a more popular page.
     
    David Pankhurst, Jun 28, 2008 IP
  3. Zhu

    Zhu Well-Known Member

    Messages:
    321
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #3
    Thanks for your reply.

    I tried adding a new user to my database (so new username and new password) but it still doesn't work. Doesn't look like the problem is on my side... Wp_config looks right.

    I contacted Site5 customer service over two hours ago, no reply yet (I know, two hours isn't much...). My blog is two years old and I can't even imagine losing it, I must be kinda geeky cause... I'm freaking out!

    I'm not sure what you mean by "refreshing the site"...?
     
    Zhu, Jun 28, 2008 IP
  4. David Pankhurst

    David Pankhurst Member

    Messages:
    39
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #4
    By refreshing I just meant refreshing your bowser - if the page came form time to time it might be someone hogging your db (I just checked - it's not).

    I also researched and found that localhost is the proper name on that site, so that's not the problem.

    A big question is what (if anything) is new on your site? Anything added, or an email from tech support saying they were changing something, or performing maintenance?

    My recommendation is to download a copy of your wp-config.php for backup, and at the same time confirm all the information is correct. Other than that, you may have to wait on tech support - but make sure they know when the problem first occurred so they can figure out what happened.
     
    David Pankhurst, Jun 28, 2008 IP
  5. Zhu

    Zhu Well-Known Member

    Messages:
    321
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #5
    Thanks for your feedback - you're the only human who replied about the problem tonight! ;-)

    Nothing is really new on the site. When the problem happened suddenly (I just refreshed a page and got the infamous error message), I was setting up an archive page. So not much really, I didn't touch wp_config (the file is definitely fine and I have backups) and I restored whatever php page I was editing.

    I don't have access to my dashboard so I can't even deactivate plugins etc. But I'm confortable enough with php and my blog in general to say I didn't touch anything sensitive (happened to me before but I have always been able to fix my mistakes!)

    I wrote to Site5 over three hours ago and got no reply. It's very frustrating...
     
    Zhu, Jun 28, 2008 IP
  6. Neptune

    Neptune Well-Known Member

    Messages:
    1,465
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    108
    #6
    It sounds to me as though their sql server is down. First thing i can recommend, is get a different host. Site5 is notorious for "losing" people's information. If you can get in touch with anyone ask them to restart mysqld. I bet that will fix the problem.
     
    Neptune, Jun 28, 2008 IP
  7. Zhu

    Zhu Well-Known Member

    Messages:
    321
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #7
    Thanks for your advice Neptune.

    I have fresh (one week old) backups at least!

    I'm getting very frustrated with their support. I posted a ticket almost four hours ago now and still have no reply. That's b*******. I understand they can't work that fast but do they understand how frustrating it is for us to sit around and wait?

    I tried everything I could on my side, I leave it to them now. Whenever they feel like replying...!

    Their forum is dead as well, I posted there but nothing.

    Funny thing is, no server seem to be down according to them (no post in forum etc)
     
    Zhu, Jun 28, 2008 IP
  8. Zhu

    Zhu Well-Known Member

    Messages:
    321
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #8
    My blog is still down and I got no reply from Site5 yet (17 hours...). I'm getting pretty desperate!
     
    Zhu, Jun 29, 2008 IP
  9. IGiveMoney

    IGiveMoney Peon

    Messages:
    116
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #9
    are the tables still in tact in the sql?

    Maybe a repair of the database tables will help correct the problem.

    if you need some help send me a pm im REALLY good with WP
     
    IGiveMoney, Jun 29, 2008 IP
  10. Zhu

    Zhu Well-Known Member

    Messages:
    321
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #10
    I'm back online thanks to an helpful soul! Looks like it was a MySQL problem on the server side.

    IGiveMoney, thanks for contacting me and sorry it got solved within 30 min. of you PMing me! Good luck ;-)

    Thanks to all of you who took time to answer this thread. I appreciate it!
     
    Zhu, Jun 29, 2008 IP
  11. David Pankhurst

    David Pankhurst Member

    Messages:
    39
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #11
    My pleasure - I'm glad your data was intact!
     
    David Pankhurst, Jun 29, 2008 IP