MariaDB not working after restore

Installation Home Assistant OS
1

Hi all…

I hope some one can help me getting my MariaDB working again.
Unfortunately i broke something in my HA and choose to restore from a backup.

After the restore i’m getting this in my log, and the recorder isn’t working

image
image1324×250 24.8 KB

image

This is from the MariaDB addon log

2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=219] log sequence number 4570010857 is in the future! Current system log sequence number 4570006971.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=220] log sequence number 4570012887 is in the future! Current system log sequence number 4570006971.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=400] log sequence number 4570012887 is in the future! Current system log sequence number 4570006971.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=339] log sequence number 4570015605 is in the future! Current system log sequence number 4570006971.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=382] log sequence number 4570015795 is in the future! Current system log sequence number 4570006971.
2020-04-18 23:22:13 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2020-04-18 23:22:13 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo
2020-04-18 23:22:13 0 [Note] InnoDB: Trx id counter is 2418957
2020-04-18 23:22:13 0 [Note] InnoDB: Starting final batch to recover 30 pages from redo log.

any chance i can save my MariaDB database?

2

From experience, I find it easier to just copy the config to a txt file. Then uninstall and the reinstall MariaDB, copy over the saved config. Starting fresh.

Sorry not the ideal answer your seeking. Ive searched for the same a few times and come to the conclusion it’s just easier to start again.

Hope its of help.