Got an error durring import of converted database

[zzozz]

• What Grafana version and what operating system are you using?
  OS Debian 12
  Grafana Version 9.5.20 (commit: 1ba5cd985398b8b7d399cbcf11aaa03234d1fa42, branch: HEAD)
  SQLite version 3.40.1 2022-12-28 14:03:47
  mysql Ver 8.4.4 for Linux on x86_64 (MySQL Community Server - GPL)

• What are you trying to achieve?
  Convert and import sqlite default grafana database into mysql

• How are you trying to achieve it?
  Using this repo: GitHub - 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.

• What happened?
  i got an arror: ERROR 1146 (42S02) at line 2: Table ‘grafana.license_token’ doesn’t exist

• What did you expect to happen?
  Not getting any errors and starting the grafana server without any problems

The connection between grafana server and mysql is working.
I check are there any tables in the database after i start the server and when i check there were allot of tables.

[yosiasz]

IS the grafana version that is now using the migrated data in mysql still Grafana Version 9.5.20?

[thiagorodrigues]

This is related to the license_token table mentioned in the error message.
This is likely happening because the database-migrator tool is trying to import data into a table that doesn’t exist yet in your MySQL database.
You can try the steps:

1. • Configure Grafana to use your MySQL database

• Start Grafana once to let it create all the necessary tables
• Stop Grafana

2. Then run the migration tool:

• After Grafana has created the tables, run the database-migrator again
• This will import your data into the existing schema

If you still encounter errors, you might need to modify the generated SQL file:

• Open the SQL file generated by the migrator
• Comment out or remove the statements related to the license_token table
• Run the modified SQL file against your MySQL database

[zzozz]

I used chatgpt to help me fixing database.
The database that is created by grafana from the initiation of the service did not have some of the tables that exported database have.

So i created the tables and imported successfully