https://bugs.kde.org/show_bug.cgi?id=439769
--- Comment #3 from Ricardo J. Barberis <ricardo.barbe...@gmail.com> --- I had already done a mysql_upgrade and akonadi's mysqld wouldn't start, so in case this helps other people with a broken akonadi, here's what I did (YMMV): - Under "[mysqld]" in ~/.local/share/akonadi/mysql.conf I added: "innodb_force_recovery = 2" - Made sure it and akonadi were not running, and started mysqld with: /usr/libexec/mysqld --defaults-file=/home/myuser/.local/share/akonadi/mysql.conf --datadir=/home/myuser/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid & - Then I backed up akonadi's DB and deleted it after: mysqldump -Q --socket=/run/user/1000/akonadi/mysql.socket --add-drop-table akonadi > akonadi.sql mysql--socket=/run/user/1000/akonadi/mysql.socket -e "DROP DATABASE akonadi" - Stoped mysql: mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown - Downgraded MariaDB 10.6.4 to 10.5.11 and started akonadi to recreate its database: akonadictl start - After a few seconds I stopped akonadi and restored the SQL dump: /usr/libexec/mysqld --defaults-file=/home/myuser/.local/share/akonadi/mysql.conf --datadir=/home/myuser/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid & mysql --socket=/run/user/1000/akonadi/mysql.socket -e akonadi < akonadi.sql - Shut down mysql, started akonadi again: mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown akonadictl start - Started kmail and everything looks good so far! (Before trying all of this , out of caution, I made a backup of my mail folder and everything related to akonadi and kmail I found under ~/.cache/, ~/.config/ and ~/.local/) -- You are receiving this mail because: You are watching all bug changes.
