To do this reliably, you’re going to have to fetch each user and pull in the meta then write it out again 1 by 1.
Use a custom WP CLI command to do this. If you don’t have SSH access you can pull down a copy of the site and run it on your machine locally then push the changes back up
Related Posts:
- SQL – Shorter way to query user and usermeta data
- How to implement LIMIT with SQL Server? [duplicate]
- how to get list of all users and their metadata
- How to make a custom column on the Users admin screen sortable?
- wp_update_user doesn’t update and update_user_meta does
- remove user_meta data from database for all users
- How to get last login Access Date and time
- How to get user metadata for social media url?
- Admin user edit – Grab newly submitted user meta immediately after update/submit
- wp_get_current_user in custom file returns 0
- SQL query equivalent to WP User Query
- Customizing WP tables or adding new ones?
- Are the default entries for a user in wp_usermeta documented?
- Error establishing a database connection After Copy localhost wordpress site (with site url directly to hosting server’s url before copy)
- SQL to check how many sites a user is a member of
- update_user_meta adding new rows in db for same key
- How to Move Local Singlesite Database to Remote Multsite Database?
- Allow role to edit users at lower level with only specific metadata
- User meta conventions / name registry, for social media links
- Get user’s ID on logout
- Sanitize textarea instead of input
- Multiple User-Meta Values in One User-Meta Key
- Getting $user_id for the_author_meta outside the loop in multisite
- Gravity Custom Merge Tags [closed]
- Update user meta through a front end form
- What is the difference between get_the_author_meta() and get_user_meta()?
- Can I prevent “wp_user_level” from getting added to wp_usermeta on registration?
- Get the Google+ and Twitter links – WordPress SEO plugin
- Showing all users who match 2 meta fields with current user
- Adding current user’s ID to the end of PDF hyperlinks in post content
- Send mail to user only once when specific check box is selected and updated from profile meta updated by admin
- add custom field in user register form
- Why get_users() not working on the admin backend?
- Can I set user meta for theoretical user 0?
- Is there a way to append meta data without creating a race condition?
- WordPress Database Huge wp_usermeta Table
- I want to update my user meta table
- Subscribers Group User meta delete
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- get_user_meta returning empty when it’s NOT empty
- Multiple meta values for one meta key
- When is a user’s meta data table loaded?
- Better way to migrate to server?
- WordPress SQL Issue not returning correct reselts
- How do I add a dropdown list of numbers 1 – 1000 as an extra profile field?
- Get user meta for only the keys with a certain prefix
- Serializing User Role for update_user_meta
- Get user_meta values for a user for an array of meta_keys?
- Fetch user related data
- add_user_meta allows multiple clicks and inserts more than 1 value
- Add user meta fields on creating the user
- Order By Meta_key but convert custom date to Y-m-d first
- Combining wp_list_authors with get_user_meta
- How to order users by a date in the meta_value array
- How to order custom fields in the user profile (admin area)
- Should I have a single cron job that loops the users, or one for each user?
- Save editor’s value in user meta and retrieve it
- Exclude specific user_id from args in get_comments
- How do I sort a WP_USER_QUERY by multiple meta fields?
- WP_Editor not saving data in user_meta
- SELECT from wp_users, get Displayname too
- Display Country Flag in Profile WordPress/Buddypress
- gform_after_submission not working as expected [closed]
- Remove user id’s stored in arrays that themselves are stored in user meta of another user
- Fetch user’s using Last Name
- How to get metadata (in my case mail) of users who have a certain set of metadata?
- How can I search user meta by a partial key name?
- How to get image path from id using SQL
- user metadata in json format, update the data partly only
- get_user_meta value is stored within strange characters
- check metadata in wordpress
- wp_redirect not working after update_user_meta
- profile_update works on second update only
- How to remove the url format from the WEBSITE field in the user registry?
- users joined group count in buddypress
- Adding user metadata to all users
- A query to substitute images paths in gutenberg (website migration)?
- Get user count based on multiple meta key values?
- Existing user_meta fields not updated
- WP author meta disappeared
- How can I track who clicked what in my member area?
- How to gets users EMAIL by their USERNAME
- Get user meta on registration hook
- Storing data to database and user registration
- update_user_meta inside a popup/modal
- add_user_meta() vs update_user_meta()
- Get all data form users and users metakey
- How to get user meta value in wordpress
- How to display checkbox meta array values one by one?
- Fetch User Meta Data
- How to toggle delete/update user meta values?
- User management missing after migration to new host
- Reordering fields in registration form via custom plugin
- Multidimensional array problem with update_post_meta [duplicate]
- CRM and newsletter integration? [closed]
- Strip Twitter Username from Profile Field with URL and Save to New Profile Field
- Custom user meta values in shortcode
- Update another users meta
- How to dump a Microsoft SQL Server database to a SQL script?
- Can’t display user bio