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

[Maik Qualmann]

Use the last digiKam-6.0.0-beta3 from 08.12 from here:

https://files.kde.org/digikam/

This is important for the migration because this version fixes potential bugs.
Then use the migration tool to either export the database to a SQLite DB and 
then import it back to MySQL. Or create an additional digiKam database and 
export the broken ones to the new one.

Maik

Am Montag, 10. Dezember 2018, 13:35:49 CET schrieb 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