hello,
i have upgraded grafana from 10.3.3 to 11.4.0 i had 40 dashboards but now i only have 15 left. i checked the grafana.db from a backup and there the dashboard are present just fine. but after the upgrade they are not in the database anymore. please advise how i need to proceed to restore my dashboards.
any updates ? , i’m facing the same issue
hello @aghapymikhail welcome to grafana community
are you using default database (grafana.db)??
please take backup of your db before upgrade
which version of grafana you are using ??
backup your plugin , datasources
which os you are using windows or linux??
i use Grafana version 11.1.0 and want to upgrade to version 12.4.2 , yes i’m using the default db path the data is in data = /var/lib/grafana and db file is in /var/lib/grafana/grafana.db i toke backup from this file, i use RHEL 9
hello @aghapymikhail please follow the step
stop grafana service
create new fresh database Grafana_DB
restore the backup database to new database Grafana_DB
now correctly update the grafana version and point it to your Grafana_DB grafana automitacially migrate the tables. and all the dashboard are present.
please check before update and after update dashboard table which also check both table schema. i follow these steps i used postgresql for grafana database.
set the grafana.ini file database configuration
[database]
type = postgres
host =xxxxxxxxx:5432
name = Grafana_DB
user = postgres
password = postgres
ssl_mode = disable
Thanks