On Wednesday, 16 August 2017 08:40:02 UTC+1, Martin Steigerwald wrote: > Hello. > > I am just forwarding it for all users that are using KMail / KDEPIM. > > I think you Akonadi shouldn´t require you to be a database admin, but maybe > my simple tips may be of some help to you. Usually MySQL will run even > without > being upgraded… however there are chances it will run *better* if you keep it > up to date. And it will create less noise in the log. > > Thank you, > Martin > > ---------- Weitergeleitete Nachricht ---------- > > Betreff: Database maintenance > Datum: Mittwoch, 16. August 2017, 09:33:28 CEST > Von: Martin Steigerwald <mar...@lichtvoll.de> > An: kdepim-us...@kde.org > > Hello. > > Today I found again some errors in mysql.err, that some innodb stats table > does not exist. There are wild help blog posts available to create those > manually by pasting page long mysql create statements into your mysql client. > Don´t. > > In my case the errors didn´t prevent startup of Akonadi, but I still wanted > to > clean MySQL log file again. In my company accoun even the complete mysql > database was missing… I don´t want to know anything about why that is the > case. It might be that I messed it up at some time… even with a time machine > I > wouldn´t know to what time to go back to exactly check what happened there. > > Anyway, in case you have messages like missing tables in mysql or information > database and things like that, or even on any major MySQL or in my case > MariaDB update, you can just run: > > mysql_upgrade --socket ~/.local/share/akonadi/socket-merkaba/mysql.socket > > while MySQL is running. Says: While Akonadi is running. > > Of course to complete the maintenance you can also run: > > akonadictl fsck > > and > > akonadictl vacuum > > (later only if you have enough free space) > > > In my point of view Akonadi should handle at least the mysql_upgrade thing > automatically (or not use a RDMS). It shall not require the user to be a > database admin. > > Of course it can also help to document the above in user wiki. Feel free to > copy&paste if you go about it. > > Thanks, > -- > Martin > > ------------------------------------------------------------- > -- > Martin
This fails for me as I cannot connect to mysql as user or unix root. I'm don't know which users are enabled for the akonadi embedded mysql as opposed to the system one (not in fact installed on this machine) mysql_upgrade --socket ~/.local/share/akonadi/socket-hostname/mysql.socket Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Error: Failed while fetching Server version! Could be due to unauthorized access. FATAL ERROR: Upgrade failed Any suggestions?