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
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.
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.
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.
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.
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?
