Hi
we have a grafana that is using SQLite as the backend and now it is getting very big so we want to migrate the data to MySQL, is there any safe way to perform this?
Hi @nesabian ,
The Grafana team maintains a handy script for migrating grafana configuration data from SQLite to MySQL.
check this out:
You might also like this long thread on the same topic:
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…
1 Like