copying user setting

i run a network I need to copy all the s2 user settings from one blog (blog id 11) to another (blog id 7). is there a way to do this. better question, what do I need to do to do this

Hi Mike.

What do you mean by user settings? The userbase, s2Member’s options or clone the site?

i mean the user settings. LIke subscribed users have data that associates their user data with paypal subscriptions, and s2 levels. i need to move those settings from blog 11 to blog 7. i imagine this involves simply fiddling with some of the data in the database, but I need to know where that data is stored, and how its represented, so i can do the modifications.

does this help?

Ah, got ya. Yeah, that’s in the usermeta table.

A simple way to migrate that would be, if you have s2Member Pro in both blogs, to export the users in one and then import/update them in the other. [hilite path]Dashboard -› s2Member® -› Import/Export -› User/Member[/hilite]

I hope that helps. :)

i do have pro installed. the export function however exports 250 lines, but the import functin only imports 100. so they don’t work that well. can you tell me how the data is represented in the database. maybe I can just go in there and make the changes.

I don’t know the exact format for that data, but it’d be in the usermeta table. Look for entries that s2Member made. Some will be serialized arrays too.

If you don’t need them in the first blog anymore, you could just update those users’ blog ID to the other one.

If you don’t need them in the first blog anymore, you could just update those users’ blog ID to the other one.

how do I do that?

With a MySQL query. I’m not very familiar with multisite. As far as I know, all the network users are in the same table, and they have a blog ID to know to which one they belong. If that’s correct, then do a query in phpMyAdmin to udpate those with blog ID __ to blog ID __.