I think I am trying to do quite a simple thing, but I am hitting a block. I want to take a backup of a single database schema from a server and apply it in another instance of (Percona) MySQL 5.6.
I have followed carefully the instructions here: http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/partial_backups_innobackupex.html#restoring-partial-backups
The part that does not work for me is:
“It can also be done by copying back the prepared backup to a “clean” datadir (in that case, make sure to include the mysql database). System database can be created with:
$ sudo mysql_install_db --user=mysql”
I am able to copy back OK, but I am unable to create the system databases properly and start the MySQL service. What does “make sure to include the mysql database” actually mean? Just take a copy from the remoter server or move the local database out of the datadir, copy back then move it back in again? Everything I have tried has not worked, the MySQL service will not start and the logs state:
: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
/etc/init.d/mysql: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
/etc/init.d/mysql: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
The restoring individual tables method is not really open to me as the schema has nearly 300 tables.
This is a trivial operation using mysqldump but it is proving hard to get working using innobackupex.
Any advice welcome.