On 5/26/23 11:39, Dr. Thorsten Brandau wrote:
When I use mysqlcheck I get
Warning : InnoDB: The B-tree of index PRIMARY is corrupted.
mysqlcheck -r bacula returns
"storage engine does not support repair"
So, the B-Tree is still corrup on PRIMARY.
OK. If that is the only problem, and there is plenty of free disk space
(AT LEAST the size of the File.ibd file), this SHOULD be straightforward
to repair.
Try this:
ALTER TABLE File DROP PRIMARY KEY, ADD PRIMARY KEY (FileId);
That will recreate the corrupted index. Expect it to take a while. If
NOTHING ELSE is corrupted, you should be good.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
