topic Re: Alfresco full backup ? in Alfresco Archive

Alfresco full backup ?

vpoorboy — Thu, 03 Aug 2006 17:31:15 GMT

Hi, I want to write a script that backup all of alfresco (content, category, group, user, …). alf_data dir and a Mysql dump are enough ?

Re: Alfresco full backup ?

heiko_robert — Thu, 03 Aug 2006 22:25:35 GMT

thats all you need to do.

e.g.:

export ALF_DATA_BASE=/opt/alfresco
export ALF_DATA_DIRNAME=alf_data
export BACKUP_DIR=/backup
export DB_USERNAME=alfresco
export DB_PWD=alfresco
export DB_NAME=alfresco130

cd $ALF_DATA_BASE/$ALF_DATA_DIRNAME
mysqldump -u$DB_USERNAME -p$DB_PWD $DB_NAME > $DB_NAME.sql
cd $ALF_DATA_BASE
tar cvfz $BACKUP_DIR/$ALF_DATA_DIRNAME.tgz $ALF_DATA_DIRNAME

regards
Heiko

Re: Alfresco full backup ?

vpoorboy — Fri, 04 Aug 2006 01:30:51 GMT

Thank you ! Will we need to stop the server ?

Re: Alfresco full backup ?

heiko_robert — Fri, 04 Aug 2006 06:50:17 GMT

yes and no. it depends since you can't garantee to create both in sync (alf_dir and db backup). The file backup like done in this script takes time and if somebody adds or deletes content you will get an inconsistent backup.
To get around that you need a storage system which is able to create snapshots (which garantees db and filebackup in sync) or you just shut down alfresco during backup.

regards
heiko

Re: Alfresco full backup ?

vpoorboy — Fri, 04 Aug 2006 07:28:08 GMT

Oh, thanks ! I think so.
Have u built import/export command line tool, there's a BAT script on windows to build the class path. Have you converted it to bash script on Linux ? Converting is not much difficult, but I'm not sure whether it's enough environments on Linux.

Re: Alfresco full backup ?

rdanner — Sun, 06 Aug 2006 20:45:07 GMT

Thank you ! Will we need to stop the server ?

As was said, it depends on how complete you need the backup to be. Either you take the system off line and nothing can be added or you have to deal with the possibility that someone added data during the export.

If you need to do a hot backup:

In terms of the export capability of alfresco, I dont know how it handles this issue. I suppose it starts a transaction and exports the system in that state.

If you backup from primatives, export the database first. This will make sure your pointers all point to valid files. Backup the file store second. If you backup more files then you have pointers to, no biggie. The pointers to those files will get captured on the next backup.

Re: Alfresco full backup ?

dmusser — Thu, 22 Feb 2007 03:13:58 GMT

Everyone

I've posted a backup/restore script at: http://unrestricted-cms.blogspot.com/

I combined what was said in this post, and also found something interesting. It appears that the alf_data directory and alfresco db instance could be cross platform capable. I was able to sucessfully backup from Linux and restore on Windows. So my question here is will that be suppored :_)

Anyway check it out and if you have comments on the script please let me know it is not final yet and I'm looking to add some hooks to shutdown alfreso, and automating the creation of the database.

-D

Re: Alfresco full backup ?

unknown-user — Fri, 08 Jun 2007 12:21:38 GMT

thats all you need to do.

e.g.:

export ALF_DATA_BASE=/opt/alfresco
export ALF_DATA_DIRNAME=alf_data
export BACKUP_DIR=/backup
export DB_USERNAME=alfresco
export DB_PWD=alfresco
export DB_NAME=alfresco130

cd $ALF_DATA_BASE/$ALF_DATA_DIRNAME
mysqldump -u$DB_USERNAME -p$DB_PWD $DB_NAME > $DB_NAME.sql
cd $ALF_DATA_BASE
tar cvfz $BACKUP_DIR/$ALF_DATA_DIRNAME.tgz $ALF_DATA_DIRNAME

regards
Heiko

What do I need to change, to use this script in co-operation with an Oracle XE, instead of a MySQL database?

Maybe somebody has already done this before?!

Chris

Re: Alfresco full backup ?

xexiz — Wed, 19 Dec 2007 14:11:28 GMT

Still no news about a backup script with oracle DB instead of MySQL.. ?

Re: Alfresco full backup ?

claudio_martins — Wed, 19 Dec 2007 16:41:37 GMT

Have a look at Oracle Import/Export Utility @ Google.

Re: Alfresco full backup ?

dranakan — Wed, 16 Dec 2009 14:03:34 GMT

Hello all,

Thank you for your script Dmusser! (http://unrestricted-cms.blogspot.com/2007_02_01_archive.html)

Just a question : A mysqldump is enough to save the database ?
The document of Mysql advices to stop the service mysql and copy the files and also do a mysqldump.

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

Thanks 🙂