SQL duplication of the user meta pro data

[laurellindsay]

I am in the process of creating a rather larger wordpress multisite. At its core I am converting a previous access database to mysql, and importing that data into mysql. There is one site setup in the wordpress install and during the import we are cloning the base site for each potential multi site. That’s really all you need to know for that.

When I do the duplication or ‘clone’ process using php to grab the wordpress tables and data I am currently at a loss as to why the User Meta Pro data is not duplicating correctly. Every other plugin, and wordpress table properly duplicates/clones itself during this process.

Is there someone who can tell me the specific data entry of the plugin and if the blog id changes, I’ve looked and properly duplicated the actual plugin data BUT on each created multisite the settings are blank.

Is there a hidden field or data that I am potentially missing? Help on this would be fantastic!

Using the Export and import process manually is not realistic as the multisite is about a 100 or so sites.

At its core all I need to do is: Take the plugin data from one multisite and duplicate it for another multisite via the table data.

• This topic was modified 10 years, 4 months ago by laurellindsay.

[Khaled]

Hi,

UMP store all user’s data to wp_users and wp_usermeta table as WordPress standard, so if you clone perfectly those two table, all user’s data should be accessible.

UMP uses wp_options table to store fields, forms and settings of UMP. More specifically,
we use following keys:
user_meta_config
user_meta_emails
user_meta_export
user_meta_fields
user_meta_forms
user_meta_history
user_meta_settings

So please check data for those keys in wp_options table.

Thanks.

[laurellindsay]

Thank you Khaled, I will have a look at the tables and see what is missing. I will get back to you this weekend. Thanks.

[laurellindsay]

Khaled,

The only information that is in my wp_option table for the original site is the following:

user_meta_fields
user_meta_forms
user_meta_settings
user_meta_emails

When duplicated the wp_15_options table (the 15 is the blog number associated with the multisite and the cloned copy) contains the original wp_5_options data (The site I am cloning).

All form data, recaptcha keys, etc.. do not transfer on the clones. Is there a blog_id number somewhere in the table copy (wp_options) that needs to be corrected — something is not adding up here.

[Khaled]

We do not store any blog id for forms or fields. just make sure wp_options table are cloned properly. And what is the status of your license validation of each site? Is UMP for every site under the network shows active/validated? And which version of UMP you are using right now?

Thanks.

[laurellindsay]

Yes, its a direct duplicate of the wp_options table with the exception of the sitename and url meta key values.

The plugin version is 1.1.6 and each multisite copy is validated.

[laurellindsay]

For your reference I have used pastebin to show you my original wp_options table. This is the original site where the other options table will be cloned.

Here is the original wp_options pastebin:

http://pastebin.com/V3AacGLD

Here is a cloned copy which does not properly duplicate the plugin settings:

http://pastebin.com/W7UntnwB

I hope this helps…

[laurellindsay]

Hi Khaled,

I took your advice and started over… whatever value was causing the plugin to not update correctly has been fixed. I appreciate your help Khaled and thank you for letting me know which meta keys the plugin uses explicitly.

[Author]

Posts