Relaunch 4.2 utf8mb4 database upgrade

I think the answer to your question right now is “No”.

There is no easy way to trigger maybe_convert_table_to_utf8mb4 on sites once they were already upgraded beyond WP 4.3 on a server that didn’t meet the requirements laid out in this post:

https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/

Note that, based on looking at WP source code, it seems they moved this from 4.2’s update sequence to 4.3 (it’s no longer present in 4.2, which now has no upgrades at all), maybe hoping to get more users on board.

So that’s your answer and it sucks but is more accurate than the others ¯_(ツ)_/¯

We’re currently working on making a simple script that lets you trigger the essence of the upgrade sequence based on an action hook. If we can get it stable and working we’ll try to come back and share it here for others to use.

Our basic plan is to extract the actual db part of upgrade_430(), isolate it from the db update system, and trigger it manually.

EDIT: SOLUTION BELOW

While there’s no easy way to trigger the script, here’s a hand-coded workaround, based on upgrade_430() but designed as a drop-in.

https://gist.github.com/carlalexander/4106cfaaf405cec454ba195631bcb6bc

You could put this in a plugin, or just paste it in your functions.php. Either way it should be TEMPORARY.

It’s set up to trigger automatically when you visit https://yoursite.com/?update-utf8bm4=1

This ensures that it only runs a single time and you get to choose when (for large databases it could take awhile and you don’t want to have anyone editing a post while it’s happening).

If you don’t want to have the GET trigger just remove the add_action part and the if (!isset($_GET['update-utf8bm4'])) part.

Again: REMOVE THIS WHEN COMPLETE, you don’t want to leave a GET trigger like this lying around 🙂

Related Posts:

  1. MySQL SELECT increment counter
  2. Exclude Statement in SQL
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. WordPress Database lost auto increment
  5. Count & Display Database Queries
  6. How to integrate custom database table in WordPress and using WordPress functions
  7. How to use “TRUNCATE TABLE” MySQL statement?
  8. delete_option() and update_option() returning false
  9. How to change option recently_edited?
  10. How to initialize $wpdb?
  11. Export wordpress table to excel
  12. When importing database, it shows error
  13. How to close wpdb connection? [duplicate]
  14. Meta query interfering with orderby relevance
  15. save new data to wp_options non-post form
  16. Error establishing a database connection when migrating site to localhost
  17. Strange Deadlock database error for the query “Delete From wp_options”
  18. Strange characters on wordpress site – Not UTF8 Issue
  19. WordPress showing install screen after max_questions error
  20. Connect to live db whilst working locally
  21. PHP variable in WordPress database query
  22. Differences between add_post_meta and update_post_meta
  23. Why do wordpress store pages/posts within the database instead of files? [closed]
  24. Insert custom data to custom table on wordpress database
  25. How does WordPress store data?
  26. Query WordPress database by registered date and role
  27. Tons of Twitter rows in my database
  28. Merging WordPress posts from different databases
  29. How to replace values in WordPress DB using phpMyAdmin
  30. How do I reset a self-hosted WordPress URL?
  31. Select Multiple meta_value from WP DB; Single Query
  32. Is it possible to split database tables using HyperDB?
  33. Show content from database
  34. Customize JSON output
  35. CRUD operations using WordPress database API
  36. How do I get WordPress login to ignore the password input if a particular username is used?
  37. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  38. “Error establishing a database” connection on some sites
  39. change wp user status from wp_users table
  40. WordPress is not creating table in database after activating plugin,
  41. Is MariaDB’s Aria storage engine suitable for WordPress?
  42. Difficulty importing my live site to local
  43. How do I delete these post types in my WordPress database?
  44. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  45. How do I query wp_options for expired transient pairs with MySQL commands?
  46. WordPress returns to an old version
  47. Super slow queries from author archive pages killing my database
  48. WordPress running SQL query to update database from form
  49. How to fix database error duplicate entry
  50. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  51. WPDB SQL query with prepare() returning variable, not db value
  52. Get value form wordpress database
  53. Moving to another server database connection error [closed]
  54. Why user_pass column in wp_users table is varchar(64)
  55. Why this query is not showing any result on wordpresss home page?
  56. Best practice to limit results in get_row()?
  57. How to migrate a database from a server to another
  58. How to display content from external db with relevant urls
  59. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  60. Connect to another WP install and grab post based on custom field
  61. Which table (and column) has the content of configured get_post_meta?
  62. Serialize data before inserting into the DB
  63. how to count click tab menu and insert to database
  64. Adding prefix to WordPress database tables breaks admin capabilities?
  65. What is the best way to resurrect and update my old WordPress site?
  66. Using $wpdb | checking entered email against existing emails in db
  67. content disappearing minutes after it’s published
  68. What is the most efficient way to reset a WordPress site?
  69. wp-cli: Error establishing a database connection: undefined constant DB_USER
  70. Add pdf to a website
  71. Optimizing function that automatically creates internal links based on post title string
  72. Outputting query results
  73. Help With a Large WordPress Based MySQL Database on Shared Hosting
  74. WordPress where clauses in db select
  75. Can two domains use the same database?
  76. _wp_attachment_metadata is not being added to database when PDF files uploaded
  77. SELECT rows between two datetimes when the range is dynamic [closed]
  78. adding user_id and name to a separate table whenever a user register based on role
  79. How do I loop/iterate through posts to edit all img tags?
  80. User saved through WordPress backend does not show up in database table users
  81. How to edit posts/pages without making the change live?
  82. Correct and secure way to access a custom SQL database in a custom PHP template file
  83. How to optimise this database query?
  84. How to retrieve user data based on role using SQL?
  85. Adding featured for post using database
  86. Does WordPress Support Using Named Pipes on the Windows Operating System?
  87. get_the_terms is not working
  88. Store id from database query in cookie
  89. Split database on large site?
  90. Store the wordpress “featured image” under »wp_posts« Database table
  91. Custom metabox does not store data
  92. Return image urls with specific base string?
  93. What WordPress file is saving new users to database
  94. wordpress database error
  95. How do i get value from wp_postmeta?
  96. Link to handle $_GET request
  97. WordPress sync with phpbb
  98. featured image not showing up with mysql_connect
  99. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  100. Query a meta key using an array of values where the database value is a string

Leave a Comment