Skip to:
Content
Pages
Categories
Search
Top
Bottom

Issues importing tables between sites using phpmyadmin

  • @marvc

    Participant

    I have a post I submitted here:
    https://wordpress.org/support/topic/export-and-import-specific-info-from-phpmyadmin?replies=3

    Basically 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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • @henrywright

    Moderator

    Hi @marvc

    Whilst I can’t offer any help myself in this instance, the actual table you’re importing is irrelevant so both the WordPress and BuddyPress support forums might not be the best place to look to get help. Instead, perhaps try a phpMyAdmin or MySQL support forum. Hopefully they’ll be more help.

    @prabin04

    Participant

    hi @henrywright can you solve my this issue ? it’s urgent.

    Restrict Non-logged in user to post on group forums

    thanx 🙂

    @henrywright

    Moderator

    Hi @prabin04

    I have done, but this topic is about importing tables using phpMyAdmin so let us keep the conversation here focused on that 🙂

    @marvc

    Participant

    Not the response I was hoping for as all I’m trying to do is restore buddypress info from one site to another. These are WP/BP solutions so I don’t see how no one in either of these communities have proven and documented which by now should be a basic restore process.

    @henrywright

    Moderator

    There may well be a solution for this in the WordPress or BuddyPress community, but what I’m saying is it’s far more likely that you’ll find the solution in a phpMyAdmin or MySQL community. So don’t give up here, but be aware you have options if you don’t get a response.

    @danbp

    Participant

    Here a complete WP tutorial, in case of. (read also the comments)

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Issues importing tables between sites using phpmyadmin’ is closed to new replies.
Skip to toolbar