Migrate sqlite to mysql

[anon70503803]

Hi @nesabian,

The Grafana team maintains a handy script for migrating grafana configuration data from SQLite to MySQL.

check this out:

GitHub - grafana/database-migrator: Code to export grafana.db (sqlite) to...

You might also like this long thread on the same topic:

Migrating grafana data to new database

We’re moving our Grafana instances to new HA servers, so we need to move the data from sqlite to a MySQL/MariaDB (Galera) cluster. I’m curious if anyone has developed any handy tools for doing such a migration? Using the API and tools like wizzy is clean, but won’t move user data, so I think some sort of direct SQL migration is required. However, I’m thinking it’s best to let Grafana create the schema in MySQL, rather than trying to translate the schema from a database dump. Maybe it won’t be t…