How can I export only the"member's" area of the database ?
Using Jamroom
Two options -
1. Create a simple custom function to delete all profiles except the members in the signup quota, something like -
$signup_quota = 2; // Or whatever your signup quota is
$_s = array(
"search" => array(
"_profile_id > 1",
"profile_quota_id != {$x}"
),
"exclude_quota_keys" =>true,
"exclude_user_keys" =>
);
$_rt = jrCore_db_search_items('jrProfile',$_s);
if (isset($_rt['_items']) && is_array($_rt['_items'])) {
foreach ($_rt['_items'] as $rt) {
jrProfile_delete_profile($rt['_profile_id']);
}
}
Then import your MP3s
2. I've recently merged all profiles and users from one site to another so have a custom module to do it. It ONLY does profiles, users, and their images and not any of their media or items. I could send it to you but bear in mind that while it worked for me, its not supported and its your problem if anything goes wrong. Do backups first.
It would also need a very simple (one line) tweak so that it only moves the 'signed up' profiles and users.
So, if you went this way, you'd need to create a target JR5 site, moved the signed up members over to it, import your MP3s to it, delete the original site, then move the new site into its place.
hth
Pa
