Hello.

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 .

Code:
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld]
datadir         = /var/lib/data
however the mysqld refuses to restart:

/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:

Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
When I try to connect to mysql from command line.

The file mysql.sock does not exist anymore.
In fact if I try :

Code:
sudo find / -name mysqld.sock
Gives no result.

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.