Effective Moodle Backups

Gatt · 12-02-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 · 12-02-2009, 03:23 PM

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

HOWTO: set up ssh keys

CyberNerd · 12-02-2009, 03:25 PM

Quote:

Originally Posted by Gatt

The problem is it keeps prompting for my ssh password

Gatt · 12-02-2009, 03:53 PM

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

Gatt · 12-02-2009, 03:56 PM

yay it works

now have a fully working mirror server

Gatt · 12-02-2009, 04:07 PM

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

jeverington · 19-04-2009, 08: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

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

12-02-2009, 03:22 PM	#16
Gatt Join Date: Jan 2006 Location: Rochdale Posts: 3,447 Thanks: 287 Thanked 141 Times in 105 Posts Rep Power: 62	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

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

		EduGeek.net Forums > Technical > Virtual Learning Platforms
Effective Moodle Backups

12-02-2009, 03:23 PM	#17
powdarrmonkey Join Date: Feb 2008 Location: Alcester, Warwickshire Posts: 3,553 Thanks: 223 Thanked 494 Times in 421 Posts Rep Power: 106	Gatt: generate an ssh key and tell your server about it: HOWTO: set up ssh keys

12-02-2009, 03:53 PM	#19
Gatt Join Date: Jan 2006 Location: Rochdale Posts: 3,447 Thanks: 287 Thanked 141 Times in 105 Posts Rep Power: 62	Thanks - think its working now - just waiting on the cronjob to run ...

12-02-2009, 03:56 PM	#20
Gatt Join Date: Jan 2006 Location: Rochdale Posts: 3,447 Thanks: 287 Thanked 141 Times in 105 Posts Rep Power: 62	yay it works now have a fully working mirror server

12-02-2009, 04:07 PM	#21
Gatt Join Date: Jan 2006 Location: Rochdale Posts: 3,447 Thanks: 287 Thanked 141 Times in 105 Posts Rep Power: 62	just as well it works! dropped the Moodle database from the LIVE server instead of the mirror

19-04-2009, 08:50 PM	#22
jeverington Join Date: Sep 2007 Posts: 4 Thanks: 1 Thanked 0 Times in 0 Posts Rep Power: 0	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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)