Well after a lot of digging, I think I uncovered what happened. The clue came from the fact that I noticed it was wp_options and all alphabetically subsequent tables that lost their primary keys.
On import, first the tables are created. Next it goes through all those tables in alphabetical order and applies the primary keys and auto_increment flags. It would seem the application of keys and flags was interrupted just prior to wp_options and the failure cascaded down.
Related Posts:
- Will it break my site if I delete all transient records in wp_options table?
- Please explain how WordPress works with MySQL character set and collation at a low level
- Site stuck in “Database Update Required” loop
- What is the purpose of the option name hack_file in the options table?
- delete_option() and update_option() returning false
- How to change option recently_edited?
- store simple data in get_option()
- WP_Options ID high
- Transient RSS feeds in wp_options not removed automatically?
- Prevent changing the length of post_name column on WordPress Update
- Long option names fail silently?
- save new data to wp_options non-post form
- Is database safe after merging a branch of a more recent version over an older one?
- Huge wp_options table
- Cannot unserialize WordPress serialized values in `wp_options` table?
- WordPress DB: options-table –> 32 gzipcompression?
- How to log database changes during an upgrade?
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- What ALL can cause “Another update is currently in progress.”? [closed]
- Should I be able to run two different “close” code versions of wordpress with the same DB
- WordPress DATABASE Update Manually?
- Should I remove transients from the wp_options table?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Accidentally deleted active_plugins portion of the wp_options DB table
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- How can I transition a site from using the Beta Tester plugin to a “normal” install?
- batch UPDATE autoload value in wp_options table
- Multiple wp_options tables to share content across installs
- How to get the SQL of the changes made to the database from an update or upgrade?
- Is there an atomic way to update_option in WordPress (to ensure data integrity)?
- Does auto_load to ‘no’ in wp_options improve performance
- Check if an option exists and get its value in one hit
- My options table is huge. What can I do?
- Change options table prefix only
- When to use custom DB tables or add_option?
- Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
- In which format the data is stored in WordPress Databases?
- Database Update Required – Update from command-line
- Automate WordPress website setup with prefilled data
- Image link issues after importing a database backup to my local web server
- Need help fixing sql syntax error after WP 3.2 upgrade
- Native timestamp on wp_options option
- Whats the best practise on how to store json data from a custom settings page?
- WordPress Settings API Overrides My Previous Value
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- get_option() does unserialize and don’t remove \
- I cannot change anything in my wordpress database from within wordpress?
- Wrong url for the images while using same database for two WordPress installations
- Options table – where does my values go?
- Theme options not being sent to Database
- Multiple Address In WP-Option Value
- How do I use update_option to give me a new option name each time a form is submitted? [duplicate]
- Exclude Statement in SQL
- Can a post ID be 0?
- what is the wp_5_posts table in the database?
- Migrating data between local and development server
- WordPress Database Charset/Collate
- What is the database table for pages?
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- Hook to be used when creating a database table
- Delete all post meta except featured image
- Where is custom template file chosen for a post stored in the DB?
- Safe way to find last inserted id in a table?
- Insert custom data to custom table on wordpress database
- How does WordPress store data?
- Query WordPress database by registered date and role
- What is the easiest way to implement cascading database upgrade for my plugin?
- Merging WordPress posts from different databases
- Does WordPress MultiSite use separate MySql databases?
- Show content from database
- “Error establishing a database” connection on some sites
- change wp user status from wp_users table
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Difficulty importing my live site to local
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- WPDB SQL query with prepare() returning variable, not db value
- Get value form wordpress database
- Updating options into the wp database performance
- Why this query is not showing any result on wordpresss home page?
- How to display content from external db with relevant urls
- Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
- What is the best way to resurrect and update my old WordPress site?
- content disappearing minutes after it’s published
- What is the most efficient way to reset a WordPress site?
- Add pdf to a website
- Optimizing function that automatically creates internal links based on post title string
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- adding user_id and name to a separate table whenever a user register based on role
- How do I loop/iterate through posts to edit all img tags?
- How to edit posts/pages without making the change live?
- How to optimise this database query?
- How to retrieve user data based on role using SQL?
- Adding featured for post using database
- Store id from database query in cookie
- Split database on large site?
- Store the wordpress “featured image” under »wp_posts« Database table
- What WordPress file is saving new users to database
- wordpress database error