VPS Problems starting Mysql !!! Desperate for help!!

Discussion in 'Site & Server Administration' started by adam1987, Mar 21, 2007.

  1. #1
    It all started sunday .... all my websites which use a mysql database stoped working ... "unable to connect to database " etc...

    so i login to plesk and try and restart vps, and notice that the system service mysgld has stopped ... when i try and start or restart nothing happens it stays stopped.

    I have been calling webfusion for the last 4 days and i dont think anyone has even had a look at it yet.

    I want to know ... IF i do a VPS backup in Virtuozzo while mysgld is not working .... will it backup the mysql databases ? or does mysgld need to be running to do this ?

    If it will backup the mysql databases then i can try to reinstall VPS... but i really cant loose the mysql databases.

    If anyone else knows someway of getting my VPS back up and running please contact me !!! I WILL REWARD !!
     
    adam1987, Mar 21, 2007 IP
  2. maonnie

    maonnie Member

    Messages:
    71
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #2
    If you've got ssh access to the machine, run mysqldump -u root -p --all-databases > backup.sql Or stop mysql then tar up /var/lib/mysql (tar xvzf ~/backup.tgz /var/lib/mysql)

    That said, it would be mad to reinstall because only mysql wont start. Take a look at syslog or the error file in the mysql database directory - one of those should give you a pointers as to what's not playing ball.

    Good Luck
     
    maonnie, Mar 21, 2007 IP
  3. adam1987

    adam1987 Well-Known Member

    Messages:
    714
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Operation start with the VPS(s) VEID289976 service "mysqld" is finished with errors: #703 Can not start/stop/restart service: service "mysqld" status is not "running" after command "start".
     
    adam1987, Mar 22, 2007 IP
  4. maonnie

    maonnie Member

    Messages:
    71
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #4
    You're best off looking in the mysql.err/hostname.err file inside /var/lib/mysql - depending on your distribution the location may be different.

    Try running,

    find /var -name `hostname -s`.err

    or

    find / -name `hostname -s`.err

    As root to find the error log.
     
    maonnie, Mar 22, 2007 IP