Thank you ! Will we need to stop the server ?
thats all you need to do.e.g.:export ALF_DATA_BASE=/opt/alfrescoexport ALF_DATA_DIRNAME=alf_dataexport BACKUP_DIR=/backupexport DB_USERNAME=alfrescoexport DB_PWD=alfrescoexport DB_NAME=alfresco130cd $ALF_DATA_BASE/$ALF_DATA_DIRNAMEmysqldump -u$DB_USERNAME -p$DB_PWD $DB_NAME > $DB_NAME.sqlcd $ALF_DATA_BASEtar cvfz $BACKUP_DIR/$ALF_DATA_DIRNAME.tgz $ALF_DATA_DIRNAMEregardsHeiko
1. Shut down the MySQL server and make sure that it stops without errors. 2. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place. 3. Copy all the .frm files for InnoDB tables to a safe place. 4. Copy all InnoDB log files (ib_logfile files) to a safe place. 5. Copy your my.cnf configuration file or files to a safe place.In addition to making binary backups as just described, you should also regularly make dumps of your tables with mysqldump…http://dev.mysql.com/doc/mysql-backup-excerpt/5.1/en/innodb-backup.html
Retrieving data ...