Export and import specific info from phpmyadmin
-
Say I have a wordpress multisite multinetwork sitting on one, (old) server and I want to select specific info from the “sub-sites” onto a new multisite multinetwork. So say on the old server I have http://servers.oldsite.com and servers.oldsite.com had 52 groups. I’ve built the servers.newsite.com and now want to import the 52 groups from servers.oldsite.com. What are the final steps?
In phpmyadmin I locate wp_blogs and it shows the site & blog ID. So this helps to locate the site containing the info I want to export. So I see the site & blog ID to be 34. So I find wp_34_ and I see the tables including:
wp_34_bp_groups
wp_34_bp_groups_groupmeta
wp_34_bp_groups_membersI select each table, click export, and Go to export that table.
Next I go to the new server, launch phpmyadmin, click wp_blogs and locate the blog & site ID, 12, for the new site.
I locate and select each group, import, and upload the same file to each group.
wp_7_bp_groups
wp_7_bp_groups_groupmeta
wp_7_bp_groups_membersI navigate to the website and don’t see any groups listed.
What did I miss?
Any responses appreciated.
The topic ‘Export and import specific info from phpmyadmin’ is closed to new replies.