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 !!
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
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".
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.