Modify Database in Multi-Site wp_usermeta table

This Should Work?

ALTER TABLE wp_usermeta
ADD COLUMN old_user_id bigint(20) unsigned;

INSERT INTO wp_usermeta (old_user_id)
SELECT u.id
FROM wp_users AS u;

INSERT INTO wp_usermeta (user_id, meta_key, meta_value)
SELECT u.id, 'wp_2_capabilities', meta_value
JOIN wp_users AS u ON u.user_id = u.old_user_id;

ALTER TABLE wp_users
DROP COLUMN old_user_id;

Related Posts:

  1. In what part of the WordPress core does the users table and usermeta table get joined?
  2. Extend the wp_users table
  3. Select Multiple meta_value from WP DB; Single Query
  4. Getting all the users who have author privilege
  5. How to Access wp_usermeta Data Immediately After a New User is Created
  6. Best practice to import user base (subscribers) from one website to another?
  7. Users table missing from Database [closed]
  8. How to delete a particular row in a database table
  9. Recovering the table wp_usermeta from users
  10. Storing user submitted forms [closed]
  11. wp_insert_user not creating account correctly when ID is manually set
  12. Select From wpdb – Author/User Directory page
  13. how add more field to wp user and save it to database
  14. Move Non-WordPress users table to WordPress database
  15. How to get the id of recently registered user from database?
  16. How to get specific table by current user login
  17. update multiple user meta field based on another meta field
  18. Using wpdb to connect to a separate database
  19. WPDB Insert or if exists Update
  20. get_results using wpdb
  21. $wpdb won’t insert NULL into table column
  22. wpdb->insert multiple record at once
  23. How to define composite keys with dbDelta()
  24. Hook into $wpdb
  25. How does $wpdb handle COUNT(*)
  26. WordPress database error: [Query was empty] [closed]
  27. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  28. Search multiple meta keys at once
  29. Efficiency on displaying random authors based on large database
  30. Updating all rows of table with $wpdb
  31. How to execute mulitple statement SQL queries using $wpdb->query?
  32. Is $wpdb->prepare escaping to much? How to use it properly?
  33. When and why should I use $wpdb different return types?
  34. How wordpress accesses its own database
  35. Remove database entries where post_date > expiration date
  36. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  37. Set Display Name to first and last name (phpmyadmin SQL Query)
  38. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  39. How to use a different database to list and manage comments in the backend
  40. Cannot update custom database table row
  41. wpdb_prepare with multiple or condition
  42. Show last modified date of database
  43. $wpdb->insert is not working
  44. Extracting the post_id via the wp_insert_post action (external db query)
  45. WordPress database error – Error in SQL syntax – I can’t identify any error?
  46. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  47. Using GROUP CONCAT in my-sql query with wp_usermeta table
  48. wp_get_current_user always returns 0 continued
  49. Import users from old WP site to new one
  50. Create table from array with prepare
  51. Update from 4.5 to 4.6 failing
  52. $wpdb->insert Giving duplicates
  53. Convert user passwords to MD5?
  54. What can I do when an outside party hacks into my weblog and changes my display name?
  55. Have working sql query… trying to adjust it to use $wpdb
  56. Does WordPress store the username as a primary key in the database?
  57. multiple wordpress installation with shared usertable on an different database
  58. $wpdb->query can’t insert data
  59. How to fetch records from database WordPress
  60. AJAX wp-mysql running too slow
  61. Some weird users in database
  62. Problem migrating to localhost
  63. Connecting to a different database
  64. Get emails from users by custom field SQL
  65. How to create more than one new wpdb object?
  66. Update multiple rows in one query
  67. I cannot find the difference between these wp_capabilities values in wp_usermeta
  68. Regenerate user_nicename column
  69. access JSON results from wordpress database with wpdb
  70. Getting value from database table depending on field value
  71. wpdb->insert not inserting first variable
  72. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  73. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  74. How to get image path from id using SQL
  75. Migrate Users From laravel to wordpress
  76. User input to database
  77. generate PDF from member information
  78. Change user_nickname for author page link
  79. how restrict user to give star ratings once for a post?
  80. Help posting values to DB on submit using $wpdb->query
  81. create a table using user meta custom data
  82. How to add download link from database on custom page template?
  83. insert data from a form:: Warning Empty query mysqli::query()
  84. How can I get $wpdb to show MySQL warnings?
  85. About wp database hooks (error establishing connection)
  86. get_user_meta and umeta_id
  87. Accessing content from third party as native posts in WordPress
  88. Should I Use only wpdb Class to Write Custom Queries?
  89. Hash user emails in database?
  90. Changed meta_key value in structures, now dashboard shows zero users
  91. using same mysql user with many databases
  92. Get id from database
  93. Pulling values from a sepcific row in table
  94. import (migration) user database to wp-users
  95. Inserting into data into external DB using WPDB
  96. What is best for saving lot of extra detail of user?
  97. Insert Extra fields added in the front end registration form to DB
  98. $wpdb->insert not working for last select option
  99. WP Multisite Users Not Linking
  100. Query a meta key using an array of values where the database value is a string