SQlite to MySQL migration error

Grafana Configuration
1

When I use the procedure in github for migrating the database from SQLite to MySQL everything works well upto loading the generated grafana.sql into MySQL. I run into the following error:

[root@v5lqah0018:/etc/grafana]# mysql -u grafana -p grafana < /var/lib/grafana/grafana.sql
Enter password:

INSERT INTO `kv_store` (`id`,`org_id`,`namespace`,`key`,`value`,`created`,`updated`) VALUES (1,0,‘ngalert.migration’,‘currentAlertingType’,‘UnifiedAlerting’,‘2025-07-18 09:33:27’,‘2025-07-18 11:33:27.481075689+02:00’)

ERROR 1292 (22007) at line 289: Incorrect datetime value: ‘2025-07-18 11:33:27.481075689+02:00’ for column `grafana`.`kv_store`.`updated` at row 1

Any help would be appreciated.

2

MySQL does not store timezone offsets in DATETIME or TIMESTAMP

2025-07-18 11:33:27.481075689+02:00’

That +02:00 is timezone offset. What data type is that column in sqlite?

3

No idea, how can I check this in SQLite?

Richard

4

Tools such as db browser and maybe some other vs code plugins?

Anyways, how experienced are you with mysql and why is there a need to migrate to it from sqlite3

5

Your query work in online compiler

image
image1366×433 41.4 KB

6

pragma table_info(kv_store);
0|id|INTEGER|1||1
1|org_id|INTEGER|1||0
2|namespace|TEXT|1||0
3|key|TEXT|1||0
4|value|TEXT|1||0
5|created|DATETIME|1||0
6|updated|DATETIME|1||0

We are moving away from SQLite, because we are standardized on MySQL (MariaDB).

Richard