Thanks for the info. I managed to spend a bit of time on it today, but not enough. It looks like what I thought was a backup log was not and adding the .zip helped there. I have dumped the data from MySQL but not had the time to go through it as yet.
Debug was set to all and this showed only two lines when I tried the backup, "Error writing to database" and "Error reading from database". Changing debug to Developer gave the following when I tried to do a manual backup of one of the course:-
Error writing to database Debug info: MySQL server has gone away INSERT INTO mdl_backup_controllers (backupid,operation,type,itemid,format,interactive,purpose,userid,status,execution,executiontime,checksum,controller,timecreated,timemodified) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [array ( 0 => '8f057ac415a2423123f31d7af7478f8e', 1 => 'backup', 2 => 'course', 3 => 141, 4 => 'moodle2', 5 => 1, 6 => 10, 7 => '1370', 8 => 500, 9 => 1, 10 => 0, 11 => '391b9edf378a74ea52cb0af8687fef03', 12 => lots of stuff that goes on in line 12 13 => 1355280794, 14 => 0, )] Error code: dmlwriteexception Stack trace: line 429 of \lib\dml\moodle_database.php: dml_write_exception thrown line 1107 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1149 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw() line 87 of \backup\util\dbops\backup_controller_dbops.class.php: call to mysqli_native_moodle_database->insert_record() line 333 of \backup\controller\backup_controller.class.php: call to backup_controller_dbops::save_controller() line 137 of \backup\util\ui\base_ui.class.php: call to backup_controller->save_controller() line 91 of \backup\backup.php: call to base_ui->save_controller()
Error Reading from database Debug info: MySQL server has gone away SELECT bi.id, bp.id AS blockpositionid, bi.blockname, bi.parentcontextid, bi.showinsubcontexts, bi.pagetypepattern, bi.subpagepattern, bi.defaultregion, bi.defaultweight, COALESCE(bp.visible, 1) AS visible, COALESCE(bp.region, bi.defaultregion) AS region, COALESCE(bp.weight, bi.defaultweight) AS weight, bi.configdata , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
FROM mdl_block_instances bi JOIN mdl_block b ON bi.blockname = b.name LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id AND bp.contextid = ? AND bp.pagetype = ? AND bp.subpage = ? LEFT JOIN mdl_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = 80)
WHERE (bi.parentcontextid = ? OR (bi.showinsubcontexts = 1 AND bi.parentcontextid IN (?,?,?))) AND bi.pagetypepattern IN (?,?,?,?) AND (bi.subpagepattern IS NULL OR bi.subpagepattern = ?) AND (bp.visible = 1 OR bp.visible IS NULL) AND b.visible = 1
ORDER BY COALESCE(bp.region, bi.defaultregion), COALESCE(bp.weight, bi.defaultweight), bi.id [array ( 0 => '10582', 1 => 'backup-backup', 2 => '', 3 => '10582', 4 => '10607', 5 => '1280', 6 => '1', 7 => 'backup-backup', 8 => 'backup-backup-*', 9 => 'backup-*', 10 => '*', 11 => '', )] Error code: dmlreadexception Stack trace: line 426 of \lib\dml\moodle_database.php: dml_read_exception thrown line 960 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end() line 628 of \lib\blocklib.php: call to mysqli_native_moodle_database->get_recordset_sql() line 1373 of \lib\pagelib.php: call to block_manager->load_blocks() line 829 of \lib\pagelib.php: call to moodle_page->starting_output() line 729 of \lib\outputrenderers.php: call to moodle_page->set_state() line 2362 of \lib\outputrenderers.php: call to core_renderer->header() line 366 of \lib\setuplib.php: call to core_renderer->fatal_error() line ? of unknownfile: call to default_exception_handler()
I hope to spend some more time on it tomorrow.
