Creating a Backup of Moodle
Now that course settings are understood from the last tutorial What are the Moodle Course settings?, learning how to back up Moodle is the next topic. Moodle has its own back up feature where the site can be backed up through the Moodle dashboard. The following article will outline the process of backing up Moodle through the Moodle Dashboard.
Create a backup of Moodle through the Moodle Dashboard
- Log into Moodle
- Click Backup in the Settings on the left.
- The Initial settings page should display. There should be a list of Backup Settings that can be selected for configuring the Moodle backup. Select the values that need to be backed up and click Next.
- The next page that displays is the Scheme Settings. This is the database information that Moodle will need for the restore. To back up the entire site, select ALL. There is the option to only backup specific database information; However, for learning purposes, All the database information will be selected in this example. Click Next.
- The Confirmation and review page should load. This page will display the backup settings and the database information that is being backed up. Click Perform backup.
- After the Perform backup runs, the page should show "The backup file was successfully created." Click Continue. Congratulations, the backup of the Moodle site was successful and can be restored at a later date.
Now that the Moodle site is backed up, the backup can be restored at a later date. Please see the following tutorial on Restoring Moodle from a backup. For more information creating courses, please visit our education channel on Creating and restoring backups in Moodle. this article is also in the Getting Started with Moodle after the tutorial on Managing the Moodle question bank
You are NOT logged in. You can still browse our Support Center.
To participate within our Community Support Forum:
Getting Started with Moodle
|1.||Getting Started Guide: Moodle|
Installing and Logging in
|2.||Installing Moodle with Softaculous|
|3.||How to log into the Moodle Administrator Dashboard|
Resetting your Moodle Password
|4.||I forgot / How to reset Moodle 2.3 username or password|
|5.||How to change the Username and Password in Moodle|
|6.||Changing the Moodle admin password through PhpMyAdmin|
Front Page Settings
|7.||How to edit the Front page settings in Moodle|
|8.||Editing the summary on the Moodle Frontpage|
|9.||Inserting an iframe in the Moodle Frontpage|
|10.||Managing the Moodle question bank|
Backup & Restore
|11.||Creating a Backup of Moodle|
|12.||Restoring Moodle from a backup|
My Profile Settings
|13.||Editing the User profile in the My Profile Settings of Moodle|
|14.||Configuring notification methods for incoming messages in Moodle|
|15.||Installing a Language pack in Moodle|
2019-04-30 8:45 pm
Many times got this, and never could make a full course backup:
Debug info: MySQL server has gone away
FROM mdl_files f
LEFT JOIN mdl_files_reference r
ON r.id = f.referencefileid
JOIN mdl_backup_ids_temp bi
ON f.id = bi.itemid
WHERE bi.backupid = ?
AND bi.itemname = 'filefinal'
0 => '24328a6f2e8ce3b90875ff01f8d71c3a',
Error code: dmlreadexception
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1245 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1571 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1854 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
line 522 of /backup/util/dbops/backup_controller_dbops.class.php: call to moodle_database->count_records_sql()
line 2007 of /backup/moodle2/backup_stepslib.php: call to backup_controller_dbops::backup_includes_file_references()
line 34 of /backup/util/plan/backup_execution_step.class.php: call to backup_store_backup_file->define_execution()
line 181 of /backup/util/plan/base_task.class.php: call to backup_execution_step->execute()
line 178 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
line 119 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
line 322 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
line 136 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()
line 142 of /backup/backup.php: call to backup_ui->execute()
2019-05-01 9:52 am
If you're getting a database error, then you may need to speak with a Moodle Support rep. You may also need to check your database to make sure it isn't corrupted. You can find out more information on making Moodle backups here.