How to backup alfresco mysql on alfresco 3.4.c

joemarbolo — Fri, 14 Jan 2011 08:58:13 GMT

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

Re: How to backup alfresco mysql on alfresco 3.4.c

billerby — Fri, 14 Jan 2011 15:21:12 GMT

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

Re: How to backup alfresco mysql on alfresco 3.4.c

joemarbolo — Mon, 17 Jan 2011 08:38:34 GMT

thanks eric you solve my problem

topic Re: How to backup alfresco mysql on alfresco 3.4.c in Alfresco Archive

How to backup alfresco mysql on alfresco 3.4.c

Re: How to backup alfresco mysql on alfresco 3.4.c

Re: How to backup alfresco mysql on alfresco 3.4.c