Hi Roland Thanks for the guide. Pretty cool stuff! Just be aware that when backing up the database only, you will miss all properties bigger than 1024bytes as this data is kept in the DataStore [1]. You will have to sync the DataStore folders as well!
-will [1] see http://wiki.apache.org/jackrabbit/DataStore On 07.09.2014, at 11:16, Roland Polzer (via Magnolia Forums) <[email protected]> wrote: > 1. Go to drive.google.com and get a new account. You don't have to give a > phone number, just a birthdate. Write down the password and keep it in a safe > place. If you already have a Google account which you don't want to use and > you are logged in with Firefox, simply use IE or Chrome. > > 2. Enter these commands as root: > [code]# apt-get install grive > # mkdir /backup /backup/mysql /backup/google > # cd /backup/google; give -a[/code] > Now grive will display an URL. Enter the URL into your browser and follow > instructions. Enter the verification code from the web page into the running > grive -a command. Done. Now your /backup/google directory is synchronized > with Google Drive. > > 3. Generate a key file for encryption. Keep it in a safe place (not only on > the server!). > [code]# openssl rand 128 >> /backup/key.bin[/code] > > 4. Copy the following script into /backup/run.sh and change the MySQL > password: > [code]#!/bin/sh > DST=/backup/mysql > GOO=/backup/google > DBUSER=root > DBPASS=YOUR_MYSQL_PASSWORD_GOES_HERE > KEEPDAYS=7 > DATE=$(date +%Y-%m-%d) > find ${DST} -type f -mtime +${KEEPDAYS} -name \*sql\* -exec rm -f {} \; > find ${GOO} -type f -mtime +${KEEPDAYS} -name \*bin -exec rm -f {} \; > db=magnolia_author > out=${DST}/${db}.${DATE}.sql > enc=${GOO}/${db}.${DATE}.bin > echo "dumping" > mysqldump --opt -c -e -u ${DBUSER} -p${DBPASS} $db > $out > echo "zipping" > gzip -f $out > echo "encrypting" > openssl aes-256-cbc -in ${out}.gz -out $enc -pass file:/backup/key.bin > #db=magnolia_public > #out=${DST}/${db}.${DATE}.sql > #enc=${GOO}/${db}.${DATE}.bin > #echo "dumping" > #mysqldump --opt -c -e -u ${DBUSER} -p${DBPASS} $db > $out > #echo "zipping" > #gzip -f $out > #echo "encrypting" > #openssl aes-256-cbc -in ${out}.gz -out $enc -pass file:/backup/key.bin > echo "grive" > cd $GOO > /usr/bin/grive > echo "done"[/code] > > 5. Add the following line to /etc/crontab > [code]11 2 * * * root /backup/run.sh > /var/log/backup.log 2>> > /var/log/backup.log[/code] > > 6. To restore, you decode the backup file with [code]openssl -d[/code]. Then > use [code]mysql -u root -p magnolia_author < filename[/code] > > Cheers, > Roland (freelancer, Munich) > > -- > Context is everything: > http://forum.magnolia-cms.com/forum/thread.html?threadId=2292fa3b-4fbf-4a3d-999f-122037db0f09 > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
