mysqlcheck -u user -p"password" --all-databases --check --fast --auto-repair
ilforum_ilfdb.searchlog Table is already up to dateDELETE FROM searchlog WHERE dateline < 1736413517;
#1194 - Table ‘searchlog’ is marked as crashed and should be repaired
I can browse that table content in PHPMyAdmin, but on last page it also returned the crashed warning.
After all what worked was replacing “–check --fast --auto-repair” by “–fast --repair” but it was significantly slow, doing the task also for big tables.
So can i modify my one-liner which checks all the databases and its tables and really repairs the crashed ones?
So far I know, i can only repair defined table using: “REPAIR TABLE searchlog;”
10.6.20-MariaDB-cll-lve
searchlog table: MyISAM utf8mb3_unicode_ci