Announcement

Collapse
No announcement yet.

Repair / Optimize Tables & Fix Unique Indexes Not Fixing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Repair / Optimize Tables & Fix Unique Indexes Not Fixing

    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?

  • #2
    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.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.4 Demo
    AdminAmmo - My Cloud Demo

    Comment

    Related Topics

    Collapse

    Working...
    X