topic MySQL wont start in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mysql-wont-start/m-p/271000#M224130 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Everything was copied to the correct place but when i try and start MySQL i get the following error:</SPAN><BR /><BR /><SPAN>mysqd_saae Logging to 'opt/alfresco-3.4.d/mysql/data/mysqld.log</SPAN><BR /><SPAN>msqld_safe starting mysqld.bin daemon with database from /opt/alfresco-3.4.d/mysql/data</SPAN><BR /><BR /><SPAN>mysqldd_safe mysqld from pid file /opt/alfresco-3.4.d/mysql/data/localhost.localdomain.pid ended</SPAN><BR /><BR /><SPAN>/opt/alfresco-3.4.d/mysql/scripts/ctrl.sh mysql could not be started.</SPAN><BR /><BR /><SPAN>I've looked in the temp folders in mysql/temp and there empty.&nbsp; I did get it working yesterday but did that many things I cant think on what fixed it for me.</SPAN><BR /><BR /><SPAN>Anyone know any quick pointers.&nbsp; It seams like the database has lost where it was and needs to rebuild its tmp files dir.</SPAN></BODY></HTML> Thu, 10 Mar 2011 13:38:31 GMT bensewell 2011-03-10T13:38:31Z MySQL wont start https://connect.hyland.com/t5/alfresco-archive/mysql-wont-start/m-p/271000#M224130 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 follo Thu, 10 Mar 2011 13:38:31 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-wont-start/m-p/271000#M224130 bensewell 2011-03-10T13:38:31Z Re: MySQL wont start https://connect.hyland.com/t5/alfresco-archive/mysql-wont-start/m-p/271001#M224131 <HTML><HEAD></HEAD><BODY><SPAN>Got it going again.&nbsp; Turns out when percona's innobackupex does its backup and copy-back routines it does something with the file permissions.&nbsp; Ran chow command to resolve it.</SPAN><BR /><BR /><SPAN>ran sudo chown -R mysql:mysql /opt/alfresco-3.4.d/mysql/data </SPAN><BR /><BR /><SPAN>This allowed the mysql database to be started using the usual ./afresco.sh start command.</SPAN></BODY></HTML> Fri, 11 Mar 2011 15:26:20 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-wont-start/m-p/271001#M224131 bensewell 2011-03-11T15:26:20Z