17 August 2010, 23:21

Hello All,

I have been banging my head against the wall trying to find a simple way to automate my back up system for Mahara running on an Ubuntu server. As it stands now, I manually do a mysql dump and then take that along with the maharadata folder and copy and paste them onto a remote server.

Whenever I try to automate this, I run into login/permission/etc. probelms.

It seems like such a simple process, yet I can never automate it.

Does anyone out there have any simple solutions?

Thanks in advance,

Mike

22 August 2010, 19:55

Hello Mike, can you elaborate on the login/permission errors you are getting?

I have an automated process which works fine for us, probably not the most efficient, but does the job OK. It uses a similar process to yours - dumping the dB into maharadata, copying and compressing the directory locally, then secure copying it to a remote server.

22 August 2010, 21:38

Thanks for the reply - I would love to see your process. 

I was hoping to be to automate backups without being logged in as root. That is the only way I have ever been able to automate and get over permissions issues.

Mike

23 August 2010, 20:55

Try something along these lines. You shouldn't need to be root to perform this. I'm assuming you have public/private key set up for authentication so you can automate this in a cron.

On the Mahara server:

mysqldump -A > /var/maharadata/prod_dump.sql

rsync -a -r -e /var/maharadata [email protected]:~/MaharaBackup