BrnDmp

Moodle Backup

Wednesday, February 6th, 2008

Discussion about Moodle backup functionality; From a technical perspective there are two issue: disk space cpu issue 1 is a non-issue. Disk space is cheap and solutions are plenty. Just built a huge SAN or NAS with RAID10 or 5 SCSI or SAS disks. issue 2 might be an issue, especially with performance under a Windows environment. If you have a load balanced environment you can dedicate one app server to do the backups. Or dedicate a single server to do the backups. We are talking default Moodle backup functionality here, as is optional under the settings Course->backups.

Posted in BrnDmp | No Comments »

MySQL postgreSQL

Wednesday, February 6th, 2008

Damn, my beautiful code didn't quite smoothly migrate from pg to my. The update syntaxt is considerably different: pg: UPDATE table1 SET table1.column =  table2.column FROM table2 WHERE my: UPDATE table1,table2 SET table1.column = table2.column WHERE I think I should use the Moodle function from the dmllib set_field_select() where you can set a field in the table where a select ...

Posted in Uncategorized | No Comments »