The instructions below are one way to back up a MySQL database. The right way to back up your database depends on which database system you are using. The Moodle code (Creating a backup of your Moodle site Database These contain information that will change most often. Generally speaking, the database ("dbname and prefix") and the uploaded files (dataroot) are the two most important to copy on a regular basis. $CFG->wwwroot points to where the code is stored.$CFG->dataroot controls where the uploaded files are stored and.$CFG->prefix shows the the database table name prefix.You can confirm where all these things are located in a Moodle installation by checking the config.php file. The Moodle code (For example, everything in server/htdocs/moodle).The uploaded files (For example, site and course files uploaded via Moodle located in moodledata).The data stored in the database (For example, a MySQL database).2 Creating a backup of your Moodle site.You can also choose to export the database in a format other than the default SQL, such as CSV or JSON. If you want to export the entire database, then just press the Go, but you can also choose to export only certain tables, change the character set and compression by checking the "Custom" in the "Export Method". Then come together when the following view:Ģ.
To create a dump of your MySQL database, go instead to the Export tab in the menu bar at the top. Once you have made your selections, click "Go" in the lower right corner. Other formats such as comma-separated values (CSV), Excel 97-2003 or Excel 2007 and XML can also be managed. Is it a normal MySQL dump so the format is SQL. Select the format of the file you're importing. This can be in plain text or compressed with gzip, bzip2, or zip.ģ. To import the data into your database, click on the "Import" in the menu bar at the top. Here you enter the username and password database when you created it.Īfter logging in you are met by the following view, which you can get more information about your database:ġ. If you are unsure of how this works, please contact support instead.īy clicking the edit button for a database, you can get additional information and also access a web-based tool called phpMyAdmin: Note: This page is intended for those who have more advanced requirements and knowledge of how to manage a database.
0 kommentar(er)
