Backup&Restore Alfresco with Mysql on Ubuntu

Cold Backup:

sudo /opt/alfresco-3.4e/alfresco.sh stop

cd /opt/alfresco-3.4.e/alf_data/ && tar cvfz /tmp/alfresco_data.tgz ./

mysqldump -u alfresco -p[password] alfresco > /tmp/alfresco.sql

 

Restore:

cd alf_data

sudo tar xvfz /tmp/alfresco_data.tgz

mysql -ualfresco -p[password] [db_to_restore] < /tmp/alfresco.sql