WEB I need a unix/server specialist for a drive/sql recovery...

Discussion in 'OT Technology' started by Yahdude, Jan 31, 2009.

  1. Yahdude

    Yahdude New Member

    Joined:
    Jun 21, 2006
    Messages:
    1,211
    Likes Received:
    0
    Location:
    PC, UT
    Basically I've got a server at softlayer, the back up crons haven't been working for 3 months (I had no idea) and now the drive is starting to croak...

    SQL won't start, password is incorrect (it's right) so I'm guessing the tables are corrupted but I'd like someone who know what they are doing to take a look and see if its recoverable.

    Any of you use a unix guy to manage your stuff?
     
  2. retorq

    retorq What up bitch??

    Joined:
    Dec 14, 2006
    Messages:
    6,061
    Likes Received:
    0
    Location:
    Mohave Desert
    Even with corrupted tables you would be able to login to the mysql command line shell ... hmmmmmm
     
  3. Yahdude

    Yahdude New Member

    Joined:
    Jun 21, 2006
    Messages:
    1,211
    Likes Received:
    0
    Location:
    PC, UT
    can't even start sql.
     
  4. retorq

    retorq What up bitch??

    Joined:
    Dec 14, 2006
    Messages:
    6,061
    Likes Received:
    0
    Location:
    Mohave Desert
    innodb tables?? I had that ONCE at work ... I think I edited my mysql.cnf and changed something in there to get it to autorepair/autocheck tem. I would have to do a search and see ...
     
  5. Deviance

    Deviance Can't you smell that smell? OT Supporter

    Joined:
    Jul 10, 2007
    Messages:
    4,984
    Likes Received:
    12
    Location:
    Rocky Mountain High
    what's it saying when it isn't starting?
     
  6. Yahdude

    Yahdude New Member

    Joined:
    Jun 21, 2006
    Messages:
    1,211
    Likes Received:
    0
    Location:
    PC, UT

    yup, softlayer support said it was throwing back some errors about the innob tables...i'll see what i can find...but I would assume for the cnf file to have any effect sql would have to at least be able to start no?
     
  7. Yahdude

    Yahdude New Member

    Joined:
    Jun 21, 2006
    Messages:
    1,211
    Likes Received:
    0
    Location:
    PC, UT

    Timeout error occurred while trying to start mysql daemon.
     
  8. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    Well, hit up the binlogs and grab a copy of all the SQL inputted and rebuild it. You did turn those on right? With proper log rotation?
     
  9. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    try running this

    mysqlcheck -r --all-databases
    and then
    mysqlcheck -f --all-databases
    and then
    mysqlcheck -o --all-databases


    also try and remove my.cnf rename it to something else and use a blank one

    also try changing mysqls root pass
     
  10. RaginBajin

    RaginBajin Have you punched a donkey today?

    Joined:
    Dec 24, 2001
    Messages:
    8,740
    Likes Received:
    0
    Location:
    NoVA
    You can also just tar up the data directory and take it to the new server.. This will work as long as the system is the same architecture (32 bit, 64 bit, etc..).
     

Share This Page