MySQL not working

[TheLG]

Type the following to see if it's actually running

ps -p $(pgrep -x mysqld) -f

You can check the status of the daemon with

sudo service mysql status

If it's appears to not be running then try starting it manually with

sudo service mysql start

it should provide output indicating if it started OK or not.

You can run the first two commands again to confirm it's running and also

ls -l /var/run/mysqld/mysqld.sock

to check that it's created the UNIX domain socket.

Thanks but when I type
ps -p $(pgrep -x mysqld) -f
I get Process ID list syntax error..
By typing
sudo service mysql status
I get mysql stop/waiting
And when I typed
ls -l /var/run/mysqld/mysqld.sock
I got No such file or directory..

[TheLG]

*BUMP*!!!
Can you please help me?
I think that I am going to reinstall my VPS but for that I need to backup my databases, can you tell me where are they located?

[SeijiSensei]

They are in /var/lib/mysql. I recovered a server for a client in the same situation. First, back up this directory. Next, on the new server install mysql, and back up the /var/lib/mysql directory it creates just for good measure. Now stop the new mysql server with "sudo service mysql stop", move /var/lib/mysql to /var/lib/mysql.bak, then copy over the old directory, and restart mysql with "sudo service mysql start". That worked for me.

You should learn how to use mysqldump to create backups of your database. I make a backup every day and copy it to a remote location over the Internet for safe keeping. You'll need to write a little script that you can run with cron. I posted one here; you're welcome to give it a try.

[TheLG]

Thank you very much for your reply.
I am going to reinstall my VPS..
But there is just one little problem, i don't have backup space, so can anybody who has 1 GB of backup space contact me in pm so i can backup my data for few hours!
Thanks!

[SeijiSensei]

Can you not copy it over the Internet with something like scp or rsync?

When I have moved things between virtual hosts, I obtain the new host first, then copy things over the Internet between the old and new virtual machines. Don't bother reformatting this machine, just set up a new one and delete the old one when you are finished. It's a lot easier and a lot safer, too.

[TheLG]

I would do that but by host does not want to give me two VMs.. Because of that I am searching for a nice person who would like to borrow me FTP account with 1GB space so I can backup my data..

[Cheesemill]

Just back it up onto your own machine, and restore it when your done.

Do you not have 1G of space free on whatever machine you are using?

[TheLG]

Hou don't understand..
I have 800 GB but if I reinstall from my panel I will loose all data!!

[Cheesemill]

Hou don't understand..
I have 800 GB but if I reinstall from my panel I will loose all data!!

You said you were after 1GB of backup space.

Just use your home computer to backup on to.

[TheLG]

Ufg, I just looked at my backup archive and it sizes 2 GB..
On my VPS I have about 800 GB free space, and if I reinstall it I will loose everything, all files..
There is an option from my hosting provider so I can buy an extra backup space but it's really very very expensive! On my PC i have very slow connection and if I try to download 2 GB file and after reinstallation upload it, that may take ages! So I am asking here if anybody here has own Server/PC with FTP and fast connection so I can backup my data there just for few hours!
Thanks again!