database-migrator

database-migrator copied to clipboard

Lost Data sources auth config when migrating

1

Hi I use Grafana 8.1.2 in docker with sqlite backend (the default). I spun up a mysql server to have an external DB, and used your script to migrate data....

Gui13

Not able to migrate secrets while migrating from sqlite to PostgreSql

1

psql:postgres_grafana_v2.sql:62753: ERROR: column "encrypted_data" is of type bytea but expression is of type bit LINE 1: ...a_keys VALUES('P1lrPhq7k',1,'root','secretKey.v1',X'684f4f43... Please find the line 62753 from the sql file below : 62753...

simplyrahul1

Support for postgresql?

1

Is postgresql support coming anytime soon? Thanks :)

mecampbellsoup

Error: near line ##: in prepare, near "-": syntax error (1)

2

Hello, I'm having error message when executing the migration script, does someone have an ideia of what it could be? Ubuntu 22.04 Grafana 10.0 Sqlite3 3.37.2 

brunoreinaldo

Timezone identifiers exported on come columns causing error on mysql/mariadb import.

3

I'm using this script to migrate a Grafana 6.6.1 installation from SQLite to MariaDB. When I attempt to import the dump with the mysql client I get the following error:...

judilsteve

ERROR 1062 (23000) at line 147808: Duplicate entry '1-GBXC3U87K' for key 'dashboard.UQE_dashboard_org_id_uid'

1

I have a problem when migration to mysql. Who can help me!! root@grafana:/opt# mysql -u grafana -p grafana < db_dump.sql Enter password: ERROR 1062 (23000) at line 147808: Duplicate entry...

TuNGO-86

Missing data

1

This script do not export table data, so it is quite useless from my point of view

msartor92

Awk Issues on Linux

11

I've had some issues using this project to migrate my sqlite database to mysql. Grafana Version: 9.1.6 SQLite Version: 3.35.5 When running the `sqlitedump.sh` script, it generates this output: ```...

bedford10

Hi we use grafana as a part of percona's monitoring and management tool. While migrating that grafana (9.2.13) from sqlite to mysql backend, we faced the following issue: Some dashboards...

klein-sipgate

Data too long for column 'data' at row 1

1

 I had to edit the exported script to remove the truncate statements for tables that didn't exist and also the timezone identifier fix then I came to this error.

louij2