Issues importing tables between sites using phpmyadmin
-
I have a post I submitted here:
https://wordpress.org/support/topic/export-and-import-specific-info-from-phpmyadmin?replies=3Basically I’ve rebuilt a site onto another server and database and only want to export certain info from the old database, which resides on another server. At this point I’m hoping to restore tables, lets say groups, to keep from having to recreate them manually.
As stated in the link posted I log into phpmyadmin on the “old” server, locate the table, select all rows, and perform an export of this same data, say:
SELECT * FROM
wp_34_bp_groups
WHERE (wp_34_bp_groups
.id
= 1) OR (wp_34_bp_groups
.id
= 2) OR (wp_34_bp_groups
.id
= 3) OR (wp_34_bp_groups
.id
= 4) OR (wp_34_bp_groups
.id
= 5) OR (wp_34_bp_groups
.id
= 6) OR (wp_34_bp_groups
.id
= 7) OR (wp_34_bp_groups
.id
= 8) OR (wp_34_bp_groups
.id
= 9) OR (wp_34_bp_groups
.id
= 10) OR (wp_34_bp_groups
.id
= 11) OR (wp_34_bp_groups
.id
= 12) OR (wp_34_bp_groups
.id
= 13) OR (wp_34_bp_groups
.id
= 14) OR (wp_34_bp_groups
.id
= 15) OR (wp_34_bp_groups
.id
= 16) OR (wp_34_bp_groups
.id
= 17) OR (wp_34_bp_groups
.id
= 18) OR (wp_34_bp_groups
.id
= 19) OR (wp_34_bp_groups
.id
= 20) OR (wp_34_bp_groups
.id
= 21) OR (wp_34_bp_groups
.id
= 22) OR (wp_34_bp_groups
.id
= 23) OR (wp_34_bp_groups
.id
= 24) OR (wp_34_bp_groups
.id
= 25) OR (wp_34_bp_groups
.id
= 26) OR (wp_34_bp_groups
.id
= 27) OR (wp_34_bp_groups
.id
= 28) OR (wp_34_bp_groups
.id
= 29) OR (`wp_34_bp_gro[…]On the new server I select the table, click Import, select the file and get the following after the import completes:
Import has been successfully finished, 51 queries executed. (wp_7_bp_groups.sql)
I see nothing when click the table.
What am I missing? Days have passed with no response so figure I’ve give a go here. So any responses appreciated.
- The topic ‘Issues importing tables between sites using phpmyadmin’ is closed to new replies.