Note: You are currently viewing documentation for Moodle 3.11. Up-to-date documentation for the latest stable version of Moodle may be available here: Database transfer.

Database transfer

From MoodleDocs
Revision as of 17:34, 20 March 2013 by Iñigo Zendegi (talk | contribs)
Main page ► Managing a Moodle site ► Admin tools ► Database transfer
Admin tools

(Additional tools may be found elsewhere in the admin settings)

The database transfer tool enables an administrator to migrate their Moodle site from one database to another, for example from MySQL to Postgres.

The tool is currently classed as an experimental feature and may be found in Settings > Site administration > Development > Experimental > Database migration. There is also a command line script in admin/tool/dbtransfer/cli/migrate.php.

The dbtransfer tool uses the XMLDB schema definitions from Moodle and installed plugins to retrieve the data from one database and transfer it another.

Some troubles you may find when using this tool:

  • If there is any object in the current database (columns, tables,...) not included in the XMLDB schema the dbtransfer won't be executed until these objects are removed (this may happen if Moodle has been upgraded from earlier versions).
  • If there is some wrong encoded data in the current database the transfer will crash; in that case find and fix the troublemaking data and launch de dbtranfer tool again.

See also

  • MDL-34441 finish dbtransfer tool implementation

Using Moodle forum discussions:

This article is a stub. Please help improve Moodle Docs by editing it and adding some content.

Retrieved from "https://docs.moodle.org/311/en/index.php?title=Database_transfer&oldid=103705"
Powered by MediaWiki