User Meta database corruption

  • Resolved 3Lancer

    (@3lancer)


    6 years, 2 months ago

    I ran “Optimize Database after Deleting Revisions” version 4.6.3 upon a development server WordPress website and it’s gone destroying the User_Meta table of the database. Not allowing any logins, even admin anymore. Haven’t had any issues from previous versions, till now.

    Under the PHPMyAdmin, the table wouldn’t open and was marked as ‘Crashed’, while previous recovery failed.

    I had to add under WpConfig.php

    define(‘WP_ALLOW_REPAIR’, true);

    Then run the tool to recover it: /wp-admin/maint/repair.php

    Might just be an once off for me and this server, but just reporting it here in case there’s an issue in the 4.6.3 build or others have similar problems. Just remember it’s always best to make backups of your server/database content too (for any major updates or database changes, not just this tool).

    Hope that can helps others out if ever running into this issue.

    • This topic was modified 6 years, 2 months ago by 3Lancer.
Viewing 1 replies (of 1 total)
  • Plugin Contributor cageehv

    (@cageehv)

    Hey 3Lancer,

    It probably was a hickup of your system, because there are no other reports of this issue.

    But, thanks for sharing!

    Rolf

Viewing 1 replies (of 1 total)
  • The topic ‘User Meta database corruption’ is closed to new replies.