Running 10.04 server and mysql 5.01.
I experimendted innobackup which made a one backup file of all databases.
Tested restoring the database by first stopping mysql service (stop mysql), extracting the backup to a new dir (/var/lib/data), modified the /etc/mysql/my.cnf to point there and to check the mysqld.sock to point to /var/run/mysqld/mysqld.sock .
however the mysqld refuses to restart:
port = 3306
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/data
/etc/init.d/mysql start will not work after upstart implementation and start mysql does not work either.
Even reboot does not help.
The error remains:
When I try to connect to mysql from command line.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The file mysql.sock does not exist anymore.
In fact if I try :
Gives no result.
sudo find / -name mysqld.sock
In one post it was adviced to point to the socket file "manually2
in my.cnf file, but as you can see from above this did not help.
I would like to use innobackup, as the backup and restore are superfast. This socket problem need sto be solved first though.
Any ideas appreciated.