Repair / Optimize Tables & Fix Unique Indexes Not Fixing

[GregJB]

This stuff never changes no matter how many times I run it.

Repair / Optimize Tables
I have a long list of results which takes a few minutes for it to process but once it does it comes back with
Status: OK
Note: Table does not support optimize, doing recreate + analyze instead
Status: OK
(a bunch of times)
at the bottom a button that says Repeat Process
I've hit repeat process 3 times and when I go back to the "Repair / Optimize Tables" tab the list is still there.


I HAVE THIS MESSAGE UNDER
and no matter how many times I hit fix

Fix Unique Indexes

If for whatever reason the UNIQUE indexes in your database have been lost (usually this happens after importing an incomplete or corrupt SQL dump) you may find strange behavior, particularly when using the language and template systems. This system will attempt to correct the problem and rebuild your UNIQUE indexes. Please ensure that the mysql-schema.php file is present in the install folder on your web server before continuing.

Is this normal to never change? How do I fix it?

[Mark.B]

Why are you trying to do all this? What problem are you trying to fix?

These are not routine maintenance tasks. You only run them if you are trying to fix a specific problem, and then only on specific tables.

Trying to run them on your entire database for no reason risks permanently damaging it.