Change DB Type

Documentation on how to transfer data to other database type like MongoDB or MySQL.

This is only available if you're running version 1.7.6 or newer.

To transfer data between different database types, you'll need to use database-actions addon, the same one that is used for 1.7.6 database format migration.

There are specific database pairs for moving data:

  • SQLite > MySQL/MongoDB

  • MySQL/MongoDB > SQLite

To transfer data from one database type to other, you need to:

  1. Download addon from this page and move folder from the zip into the addons folder (skip this if you already have addon installed)

  2. Open config.yml from that addon folder and put your ID into the transfer_access field and make sure that startup_migrate is set to false

  3. Open your bot's console so you can see if any error occur during the transfer

  4. Run the /transfer [Database From] [Database To] command. 1. Make sure that your database.type config field is set to the same database type as the one you're moving data from, if 'Database From' is MongoDB then database.type should be mongo etc.

  5. After transfer is done, stop the bot and remove the addon

Last updated