Corrupt WordPress Database

You’re probably running into the joys of MySQL’s MyISAM engine…

From within MySQL (or PhpMyAdmin), use REPAIR TABLE xyz statements again, repeatedly, on each of your tables (or rather, your terms related tables, since these are the ones that sound corrupt) to see if this solves anything.

If those fail, there are a few documented workarounds:

http://www.google.com/search?q=recover+a+corrupt+mysql+database

Once things are recovered, run OPTIMIZE TABLE xyz statements on each table, and then alter the engine of the database and each table to make it use InnoDB. InnoDB clutters the catalog somewhat (especially if you drop a database or large tables), but — being ACID compliant — it’s a hell of a lot less error prone than MyISAM.

Related Posts:

  1. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  2. Relaunch 4.2 utf8mb4 database upgrade
  3. Get error messages when $wpdb->insert() returns false?
  4. Does dbDelta delete columns as well?
  5. Where can I find the database changes between WordPress versions?
  6. Insert data in database using form
  7. When is it appropriate to create a new table in the WordPress database?
  8. Special characters in WordPress UTF-8 [closed]
  9. Split WP install between 2 databases?
  10. Prevent changing the length of post_name column on WordPress Update
  11. Why does dbDelta() not catch MysqlErrors?
  12. Accessing two databases
  13. how to transfer wordpress sql/database from local to live
  14. Is altering a default WordPress database table update safe?
  15. Get Database Credentials from within the themes file
  16. what to do when your WordPress database is too large?
  17. Change all http to https in mysql databse?
  18. WordPress DB: options-table –> 32 gzipcompression?
  19. Having issues with wp_postmeta and wp_usermeta tables too big
  20. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  21. error establishing a database connection
  22. Get data from database using $WPDB
  23. WP Database Table to CSV file
  24. Uppercase to sentence case for post titles
  25. How to retrieve and show database table in wordpress dashboard
  26. Moving to another host; which tables to move in a database
  27. WordPress mysql table double prefixes
  28. Moving online website to MAMP or dumb idea?
  29. How can I transition a site from using the Beta Tester plugin to a “normal” install?
  30. SQL Query to Update Admin Email
  31. Storing data for a wordpress plugin
  32. Transient feeds and caching error
  33. get_tags() return an empty array after added tags with wp_insert_term()
  34. Is it a bad idea to write audit/access/transaction log information directly to the filesystem?
  35. WordPress database import: Row size too large
  36. Advanced SELECT query with condtional statements
  37. Why do mass updates to post_content shows in front end, but not in edit screen?
  38. How to disable (get rid of) home page main loop entirely?
  39. How can I (semi) automate a database export and import to a different location?
  40. Insert post in another database
  41. Redirecting to old domain after migration website
  42. WordPress Database Huge wp_usermeta Table
  43. Localhost keeps redirecting to live domain
  44. How to get membershiplevel from WordPress Database?
  45. Child parent relationship inside WP DB
  46. Copying database tables to new database
  47. Duplicating Complete WordPress Install for Development and then Redeployment?
  48. I have a 1300 line excel spreadsheet that needs to get into a wordpress site ASAP – Looking for ideas
  49. What does wp_term_taxonomy.parent reference?
  50. How to combine multiple wp_insert_post into one in order to gain better performance
  51. How to get nav_menu_item_id and slug from wp database
  52. Two prefixes in database? Which one is valid?
  53. Enter user registration information in the database
  54. Is there a way to execute a php script outside WordPress?
  55. Problem in using wpdb
  56. How can I restrict php mail() to only send me one email after a db error
  57. pull data from a remote wordpress database
  58. Create database on installation
  59. How to delete post comments from the database via SQL statement?
  60. Users table missing from Database [closed]
  61. Why does changing Database Table Prefixes result in loss of content?
  62. Options on how to Display member specific data from a MS SQL database
  63. How to connect and insert data in database of wordpress?
  64. Unkown meta_value in ACF
  65. wp_option table error while importing
  66. wp_insert_user not creating account correctly when ID is manually set
  67. Installing local to live WP into subdirectory
  68. WordPress SQL – How to Check for Category?
  69. What is wrong here? Issue with post_id and meta_value
  70. Getting WordPress to work inside a rails 3 application
  71. MSQL database wp_postmeta has meta key tve_revision
  72. Deleting empty meta key values
  73. Occasional Error Establishing a Database Connection
  74. WP 5.5, child themes, customizer and a weird cache issue
  75. Display user data in numbered list
  76. Removing old_slug and old_date from WordPress Database
  77. Help with $wpdb on custom code
  78. How do I change several broken URLs in a several wordpress databases in the fastest way?
  79. Best way to store 1 billion+ posts?
  80. Optimize WP site for millions of posts
  81. What’s the easiest way to connect external database and display data on wordpress?
  82. Character encoding issue – black diamond question marks on imported post excerpts
  83. WordPress Migration – Issue with admin panel changes
  84. Reinstall wordpress/mySQL caused database problem
  85. How To connect to the same WordPress database with different database user
  86. How much post meta data is too much?
  87. I have include wp-config, should I add global $wpdb also?
  88. Localize strings from db
  89. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  90. How to have WP Search widget index dynamically generated content?
  91. Preventing concurrent update of data
  92. Redirect Issue: WordPress database
  93. Category not displaying in add post, edit post, and categories page.
  94. Creating Tables in WordPress Database
  95. Calling update_user_meta inside of another function doesn’t work
  96. $wpdb->prepare returns empty array
  97. Prevent creation of unused database tables?
  98. How to store a plain password in WordPress database in another field
  99. How to stop WordPress from using utf8mb4_unicode_ci collation
  100. Cant Connect to Database

Leave a Comment