Context Navigation

Changes between Initial Version and Version 1 of Ticket #65241, comment 12

-              initial
+              v1
 this article: (https://developer.wordpress.org/advanced-administration/upgrade/migrating/#altering-table-prefixs) you are refering to, is about the user meta data in the wordpress meta table. We are not talking about the user meta here.
+We are talking about a option in the options table that is the only option ever that uses the database prefix (and multisite_id) in a table that is already using the prefix (and in case of a multisite also the multisite_id) in the tables name.
+Moreover the by you suggested replace is only for the main table as that is the only one without a multisite_id in the table names. All others have NEWPREFIX_MULTISITE_ID_usermeta
+        UPDATE `newprefix_usermeta` SET `meta_key` = REPLACE( `meta_key` , 'oldprefix_', 'newprefix_' );
+In case you have a big multisite you have to run this per usermeta ...  that is a lot of fun.
+But here we are talking about a option in the options table that is the only option ever that uses the database prefix (and multisite_id) in a table that is already using the prefix (and in case of a multisite also the multisite_id) in the tables name.
 The adding of the prefix and multisite id to that option is completely useless and illogical. They both should never have been added to that option in the first place in which case the transfer tool, or what ever tool you use the change a prefix, would never caused any issues.