1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

My VPS Server Crashed

Discussion in 'Off Topic' started by wickedstangs, Mar 17, 2014.

  1. wickedstangs

    wickedstangs Well-Known Member

    I contacted my hosting company.. This is what they said.. What should I do?
    Please do what you have to get me back up...

    Not sure what the above means? Can you guys give me a hand..
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    They are going to charge you to do a restore from a date you specify.

    However, and this is fairly crucial as far as XenForo is concerned:
    XenForo uses InnoDB.
     
  3. craigiri

    craigiri Well-Known Member

    It sounds like they are saying they do not have backups of your db's, which is the part which they say crashed - or, they have them, but charge to restore them.......

    Maybe you should get them on the phone. The charges seem reasonable if they can restore your mysql databases.

    Often, these crashed db's can be fixed without having to use a backup.....mine usually self-repair to some extent.
     
  4. wickedstangs

    wickedstangs Well-Known Member

    So did I lose everything?
     
  5. wickedstangs

    wickedstangs Well-Known Member

    Can I try and restore the DB's myself?
     
  6. craigiri

    craigiri Well-Known Member

    If any when you get it fixed, buy your own backup service.....I use this one:
    http://myrepono.com/

    They have a specific part of the service for mysql db's......

    It cost only a few dollars per month for most setups.
     
    wickedstangs likes this.
  7. craigiri

    craigiri Well-Known Member

    If you don't know what you are doing, probably not.....

    You need to know how to use the shell in unix and all the various mysql admin commands from there.
     
  8. craigiri

    craigiri Well-Known Member

    If your set is like mine, you'd go in with the shell and first stop mysql - even if it is crashed....

    then you'd start it again....

    /etc/init.d/mysql stop

    /etc/init.d/mysql start
     
  9. wickedstangs

    wickedstangs Well-Known Member

    which program you use to get to shell?
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    Have you attempted to repair the tables?
    Which ones are showing as crashed?
     
  11. wickedstangs

    wickedstangs Well-Known Member

    not sure did you tell me..
     
  12. Slavik

    Slavik XenForo Moderator Staff Member

    Their wording might be off, it may mean they cant restore a "single" innodb database (due to how the ibdata file works).

    They may mean you have to restore the whole VPS to get it back... double check with them. If theyve done a snapshot of the entire VPS theres no reason why it wouldnt restore the database also.
     
  13. wickedstangs

    wickedstangs Well-Known Member

    went to look at db and see this..
    Code:
    Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Error from MySQL query: Can't call method "do" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.
    1.JPG
     
  14. Slavik

    Slavik XenForo Moderator Staff Member

    Do you have ssh access?
     
  15. wickedstangs

    wickedstangs Well-Known Member

    yes using winSCP
     
  16. Slavik

    Slavik XenForo Moderator Staff Member

    Probably easier to take a look directly, can you pm me the information.
     
    wickedstangs likes this.
  17. wickedstangs

    wickedstangs Well-Known Member

    conversation sent..
     
  18. wickedstangs

    wickedstangs Well-Known Member

    @Slavik this is there reply..
     
  19. Slavik

    Slavik XenForo Moderator Staff Member

    Well i've got mysql up and running, running checks on the databases now...
     
    SchmitzIT, wedgar, Brad L and 3 others like this.
  20. AdamD

    AdamD Well-Known Member

    Slavik to the rescue!
     
    wickedstangs likes this.

Share This Page