MySQL wont start

[bensewell]

Hi,

Testing out backup routines and have sucessfully had percona's xtrabackup scripts working fine and getting data ready to be restored on a blank server to do the full restore test / disaster recovery scenario.

Everything was copied to the correct place but when i try and start MySQL i get the following error:

mysqd_saae Logging to 'opt/alfresco-3.4.d/mysql/data/mysqld.log
msqld_safe starting mysqld.bin daemon with database from /opt/alfresco-3.4.d/mysql/data

mysqldd_safe mysqld from pid file /opt/alfresco-3.4.d/mysql/data/localhost.localdomain.pid ended

/opt/alfresco-3.4.d/mysql/scripts/ctrl.sh mysql could not be started.

I've looked in the temp folders in mysql/temp and there empty.  I did get it working yesterday but did that many things I cant think on what fixed it for me.

Anyone know any quick pointers.  It seams like the database has lost where it was and needs to rebuild its tmp files dir.

[bensewell]

Got it going again.  Turns out when percona's innobackupex does its backup and copy-back routines it does something with the file permissions.  Ran chow command to resolve it.

ran sudo chown -R mysql:mysql /opt/alfresco-3.4.d/mysql/data

This allowed the mysql database to be started using the usual ./afresco.sh start command.