Sqlite3 to mysql - after unified storage migration

Ask AI
1

Hi,

I am currently trying to move my grafana instance from sqlite3 to mysql, due to external circumstances.

My grafana has existed from version 10 and has been patched all the way up to 13.2 where it is now. My DB backend has consistently been sqlite3 for that time. I now want to move but when executing the migration steps as outlined here (grafana/database-migrator: Code to export grafana.db (sqlite) to MySQL-compatible SQL file, to assist in migration of Grafana data to MySQL-compatible DB.) my older Dashboard versions only get synced, with the most recent changes being the one before unified storage migration.

How do I make so that my changes that have been done SINCE the unified storage migration also get reflected? From what i understand those are represented in the resource table which I am also migrating to the new DB.

Thanks!

2

If you check the table unifiedstorage_migration_log does it show any errors.

grafana_db=# select * from unifiedstorage_migration_log;
 id |               migration_id                |                             sql                             | success | error |      timestamp
----+-------------------------------------------+-------------------------------------------------------------+---------+-------+---------------------
  1 | create unifiedstorage_migration_log table | CREATE TABLE IF NOT EXISTS `unifiedstorage_migration_log` (+| t       |       | 2026-02-24 15:28:03
    |                                           | `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL            +|         |       |
    |                                           | , `migration_id` TEXT NOT NULL                             +|         |       |
    |                                           | , `sql` TEXT NOT NULL                                      +|         |       |
    |                                           | , `success` INTEGER NOT NULL                               +|         |       |
    |                                           | , `error` TEXT NOT NULL                                    +|         |       |
    |                                           | , `timestamp` DATETIME NOT NULL                            +|         |       |
    |                                           | );                                                          |         |       |
  2 | playlists migration                       | unified storage data migration: playlists                   | t       |       | 2026-02-24 15:28:03
  3 | folders and dashboards migration          | unified storage data migration: folders-dashboards          | t       |       | 2026-04-14 11:08:58
  4 | shorturls migration                       | unified storage data migration: shorturls                   | t       |       | 2026-08-20 07:32:57
(4 rows)

When you migrate from sqlite to mysql are there any errors during migration?
Maybe count (*) from all tables in both sqlite and mysql after migration before starting Grafana.
See if there are any data differences.

3

how many dashboards do you have? Any other artifacts within your grafana?

4

I have a few dashboards in Grafana, mainly for monitoring system performance and key metrics. I also use alerts and panels to keep track of important changes.