Move from staging to live by exporting/importing DB tables

  • Resolved Firsh

    (@firsh)


    3 months, 3 weeks ago

    Hi, first of all thank you for making this plugin it is very nice and we’ll make great use of it. So I have a site with 700 members on which we want to introduce a forum. On the staging copy the user count is not growing, but that’s we use to sandbox ideas and setup/config the forum. For other reasons, we can’t just transfer back the entire staging to live, as that one is gathering new users and new content in parallel. Can I just export all the wpForo tables and import them (using phpMyAdmin or a backup plugin, etc) and do a re-sync to catch any new users, check if the page ID of the main board is right, and expect stuff to work, or am I missing something? Thanks

    • This topic was modified 3 months, 3 weeks ago by Firsh.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support gVectors Support

    (@gvectorssupport)

    Please follow this support topic: https://wpforo.com/community/how-to-and-troubleshooting-2/migrating-forums-database-to-a-new-server/#post-43682

    Thread Starter Firsh

    (@firsh)

    Thanks I’ve read it.

    Why is this step necessary? “So in the target WordPress the users tables should be overwritten with old one” Users and usermeta? The staging site does not generate any user activity, it’s just for setting up the forum behind the scenes without accidentally breaking the live site. (For example, upon merely activating the plugin, the sidebar was gone as wpForo registering a sidebar shifts the list of sidebars in WP and the Divi theme identified sidebar areas with their numerical position e.g. first, thereby emptying the sidebar unless manually fixed.)

    Also, why is there a need to move all files in ?/wp-content/uploads/wpforo/ if the test setup didn’t include any posting of images or user avatars? The only “uploads” I could think of are forum cover pictures picked from the media library.

    Plugin Support gVectors Support

    (@gvectorssupport)

    Hi,

    If the users exist on both the staging and live websites with the same IDs, it is not necessary to migrate the wp_users and wp_usermeta tables. In this case, you should only migrate the tables with the wpforo_ prefix.

    Regarding the uploads, there is not much information stored in the media library, but a lot of information is stored in the uploads/wpforo/ folder, so migrating this folder is required

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.