AnsweredAssumed Answered

MySQL wont start

Question asked by bensewell on Mar 10, 2011
Latest reply on Mar 11, 2011 by bensewell

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

/opt/alfresco-3.4.d/mysql/scripts/ 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.