How to backup alfresco mysql on alfresco 3.4.c

[joemarbolo]

I would like to ask on how i will backup mysql in alfresco-community 3.4.c? Thanks in advance

[billerby]

First I encourage you to read the wiki on backup:

http://wiki.alfresco.com/wiki/Backup_and_Restore

To backup mysql is a procedure independent to what version of alfresco you are running, however to be able to restore alfresco, the backup of the db and the data dir must be done at the same time (your question targeted 3.4.c). I have a running 3.4.c installation and I'm following the cold backup procedure described in the wiki. I found the following webpage very informative in how to backup and restore mysql:

http://docforge.com/wiki/Mysqldump

I use the following command to backup our db:

mysqldump -u username -p –default-character-set=latin1 -N database > backup.sql
‍‍‍

and the following to restore:

mysql -u username -p –default-character-set=latin1 database < backup.sql
‍‍‍

/Erik

[joemarbolo]

thanks eric you solve my problem