Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database

Yes the issue is due to the auto increment setting.

All WordPress DB specifics can be found here, which includes details on which ones use auto increment: https://codex.wordpress.org/Database_Description

This isn’t going to be an easy task, but here’s some sites to help you:
https://www.photographerstechsupport.com/tutorials/fixing-wordpress-indexes-foreign-keys-and-auto_increment-fields/

This one is specific to wp_options:
https://guides.wp-bullet.com/fixing-wp_options-table-missing-unique-column-primary-key/

Specifically the auto increment:
https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql

You need to make sure that whatever you set the auto increment to, that you take the largest number in the ID column, +1 and use that.

Basically that tells the DB next time a new row is inserted, what ID to use when doing the auto incrementation.

SO related post: WordPress Database lost auto increment

Related Posts:

  1. How can I trust switch_to_blog()?
  2. DB connection error after copying a WordPress Multisite instance to a second location
  3. Add WordPress MU Network Admin via Database
  4. How to tell which database tables belongs to which multisite site
  5. what are pmxi tables? [closed]
  6. Shared table across network
  7. find a random blogid across my multisite network that has at least one post published
  8. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  9. Multisite: How to store global options vs. site options?
  10. Uploading/Deploying a Multi Site Install
  11. Multisite database upgrade SSL error
  12. Configure WordPress to read from database only, never write
  13. Multiple Domains and Subdomains Using Multisite Installation
  14. Migrating WPMS from apache to IIS7 causes Database Error
  15. Synchronizing Two WordPress Sites Content
  16. How to clone and locally run a network for testing
  17. Two WordPress sites sharing the same database
  18. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  19. Split a database will improve performance?
  20. How to Move Local Singlesite Database to Remote Multsite Database?
  21. Multisite Subdomain Using More Resources Than Others?
  22. How to change the database prefix in multisite (WPMU) install
  23. Importing Multiple DB to one MU database
  24. Make WordPress Search for Both Main Domain and Subdomain
  25. Does WordPress MultiSite use separate MySql databases?
  26. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  27. Multisite setup creating custom table
  28. Is there a way to run upgrade.php for one blog?
  29. Within the database, where is the flag which says that a user has Super Admin rights?
  30. Bulk activate a theme on multisite
  31. Migrating Multisite – Database error, missing wp_blogs table
  32. How to store custom user data on the database?
  33. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  34. Database Tables Lost Indexes? How to Recover?
  35. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  36. Multiple multisite instances connecting to the same database
  37. WordPress Multisite – can I somehow merge the tables?
  38. Multisite with subfolders- can’t access main site- Error establishing a database connection
  39. Create a database for each site created in multisite?
  40. Use WordPress MultiSite (WPMS) with a remote database for each created site
  41. Will changing the folder name two directories above a fresh wordpress installation break the site?
  42. WordPress Multisite blogs not working after domain swap
  43. Least expensive way to get table prefix in multisite installation
  44. 2 website 1 database… Local to online
  45. new multisite, old db
  46. Removing Mutlisite lines stop DB connection
  47. how to migrate wpmu from one host to the other?
  48. Share DB tables between two blogs on the same WP Multisite installation
  49. How can I create blog specific database table in multisite?
  50. How many databases do I need?
  51. Locking one blog of many in a multi user/blog WordPress installation
  52. WordPress Multisites or Multiple WP Single sites?
  53. $wpdb->update prefixes database name to table when executing query
  54. WP MultiSite: Can’t select database error after changing to new domain
  55. Combining user database tables while keeping all other data in seperate for multiple sites?
  56. How to make multi site with single Database?
  57. Update WP install to WP network & it broke the DB connection
  58. Sharing users across multiple sites, each on their own database
  59. importing data into wordpress db
  60. How to share User Database between Two Multisite Installations + More
  61. How long is “as long as possible” in wp_cache_set()?
  62. WPMU on MySQL limited to 1GB of space?
  63. Questions about MU database schema and how to list all blogs
  64. How does WP decide how to evaluate database integrity
  65. How to use the same users table on multiple wordpress sites
  66. A database for each category?
  67. Problems with WordPress multisite directories/url structures and admin access after migration
  68. allow multisite in the installation process
  69. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  70. Will resetting my database affect other sites on my multisite WordPress install?
  71. WordPress Database Cleanup
  72. Optimal setup for Multi Domain WordPress with Woocommerce
  73. wordpress multisite – handle Database
  74. Importing Posts into New Website with Same User ID’s
  75. WordPress automatic Login on other page?
  76. How to reconnect database to existing wordpress multisite setup after changing site name
  77. Multi-site database upgrade claims success, but db_version not updated
  78. Get multisite count without php?
  79. Multiple domain with one database
  80. Problem in adding new site on WP multisite
  81. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  82. MySql Database In WordPress Multisite
  83. WP DB Location for “Next Post to Create” Index Value
  84. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  85. Plugin data shared in Multisite
  86. Merging versions of wp_posts based on post_title
  87. WordPress multisite and one database
  88. WordPress Multisite platform for different city for single db
  89. 4th Network Site Database Errors?
  90. Is there a full explanation on how to share a database with two WordPress sites on same server?
  91. HyperDB, Multisite – on new site creation put site’s tables to specific database
  92. Testing Multisites with vagrant or Can I use multisite with only an IP address (without domain name)
  93. Creating a Post form outside of the Admin
  94. How can I create a multisite global tag cloud?
  95. Override database config for WordPress multisite
  96. ‘Cheatin’ uh?’ Error When Attempting to Upload Images After 3.4 Update
  97. single sign on for wordpress multi site
  98. Filter meta request
  99. Comment reporting for Multisite
  100. How to display the most popular posts of all the blogs in a mu setup? [duplicate]

Leave a Comment