Moodle’s database tools transfer databases from one server to another, perform search-and-replace operations on text strings in the entire database, and let you view or change any data in the database itself.
Transferring your Moodle database
If you have to move the database of a Moodle instance from one server to another or migrate to another Moodle system, you have two broad options. You can either create a database dump manually (or via the Adminer tool, which is covered later) or use the built-in database transfer facility.
The database migration tool is available at
<yoursite>/admin/tool/dbtransfer. At the time of writing, the feature can also be accessed via Site administration | Development | Experimental | Database migration. As the category name suggests, the tool is experimental and might make it into core or might disappear again from the admin interface in future releases.
Figure 17.7 – Database transfer...