[digiKam-users] Corrupted digikam database repair - easy solution?

[zwyklydigikam]

Hello,
My database with 170 000 photos is corrupted (something went wrong with face
recognition or even before that, thats the time i found error after crash).
When DK starts, housands of errors in windows event viewer, two of them loop
with different numbers:
"
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but not the InnoDB log files. 
InnoDB: Page [page id: space=9, page number=3136] log sequence number
114156703 is in the future! Current system log sequence number 1649127.
"

DK is working fine i think (you wont see any error info, without event
viewer), but cannot save mysql_install_db.exe and mysqld.exe. When i click
OK and go back, still missing.
I don't know if database is corrupt because of missing .exe files or exe
files missing because of corrupted database.

I was trying to repair databse, but cannot find a good simple tutorial
without studing whole mysql books. All say, use the innodb_force_recovery =
1,2,3,4,5,6, but where, how, which ini file, i tried all of them, nothing
changes, maybe digikam is a bit different, they use different config files,
but i cannot find them on my HDD.

Maybe i'm doing something wrong, or everything, but is there any one/two
click solution to fix those errors and repair database? If its just changing
some files in confing files, why not make a button in digikam "Reapair
problems" or sth like that, aby selfheal? ;)
I could try to find a fix, probably can fix it by myself with google (i know
some IT) but lots of users, photographers have no idea how to open .ini
file, not to mention understanding windows event logs etc. 

I've installed digikam on so many computers (friends, familly...) and they
will probably lose everything one day with 1 error, without IT support
(months of tagging pictures).

BTW. I got another digikam on linux, and its ok.

Windows 10 64x
Digikam 6.0.0 beta2 64x
Mariadb 10.3.10
Mysql (experimantal)
Face recognition (experimental)
My ram and photo hdd partition without bad sectors.

Thanks!



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html