I am following Migrating grafana data to new database to migrate from SQLite3 to MySQL with grafana-5.2.4-1.x86_64 on CentOS7
When I tried importing the dump after creating the grafana database in mysql and allowing grafana to create the mysql db schema I got the error about missing table alert_notification_state.
sqlite3 grafana.db .tables
alert dashboard_version session
alert_notification data_source star
alert_notification_state login_attempt tag
annotation migration_log team
annotation_tag org team_member
api_key org_user temp_user
dashboard playlist test_data
dashboard_acl playlist_item user
dashboard_provisioning plugin_setting user_auth
dashboard_snapshot preferences
dashboard_tag quota
When i looked at the schema that grafana created I noticed that alert_notification_state table is missing.
mysql> show tables;
±-----------------------+
| Tables_in_grafana |
±-----------------------+
| alert |
| alert_notification |
| annotation |
| annotation_tag |
| api_key |
| dashboard |
| dashboard_acl |
| dashboard_provisioning |
| dashboard_snapshot |
| dashboard_tag |
| dashboard_version |
| data_source |
| login_attempt |
| migration_log |
| org |
| org_user |
| playlist |
| playlist_item |
| plugin_setting |
| preferences |
| quota |
| session |
| star |
| tag |
| team |
| team_member |
| temp_user |
| test_data |
| user |
| user_auth |
±-----------------------+
30 rows in set (0.00 sec)
Anyone has any ideas how to resolve this issue? I deleted all reference to the alert_notification_state table and it failed with the error:
ERROR 1136 (21S01) at line 1207: Column count doesn’t match value count at row 1
Any ideas?
