Effective Moodle Backups

**Gatt** · 12th February 2009, 03:22 PM

Ok got the mysqldump to work over SSH

Code:

mysqldump -uUSERNAME -pPASSWORD --all-databases | ssh user@mirror-server "mysql -uUSERNAME -pPASSWORD"

The problem is it keeps prompting for my ssh password

**powdarrmonkey** · 12th February 2009, 03:23 PM

Gatt: generate an ssh key and tell your server about it:

HOWTO: set up ssh keys

**CyberNerd** · 12th February 2009, 03:25 PM

Originally Posted by Gatt

The problem is it keeps prompting for my ssh password

**Gatt** · 12th February 2009, 03:53 PM

Thanks - think its working now - just waiting on the cronjob to run ...

**Gatt** · 12th February 2009, 03:56 PM

yay it works

now have a fully working mirror server

**Gatt** · 12th February 2009, 04:07 PM

just as well it works! dropped the Moodle database from the LIVE server instead of the mirror

**jeverington** · 19th April 2009, 09:50 PM

If i remember at the college, i setup a NAS as a auto mount disk and used the onboard moodle backup script.

Ubuntu tut for setting up a auto mount
Automatically Mounting Windows SMB Shares in Ubuntu v3 | Matt Van Stone