Migrate data between 2 WordPress
Budget: $30 – $250 AUD
On the live site, the users purchases a woocommerce product to enrol in a course created in LearnDash… the products and courses are linked together by custom plugin… the custom pugin is migrated to the staging site and all functionalities working… when we started the development on the staging site, we duplicated the live site and restore it in the staging site, the development took 4 months, so in the last 4 months we don’t have the data on the staging site. That’s what we need to now migrate from LIVE to STAGING.
We need to migrate Users, Users metadata, WooCommerce Orders, and anything related to users, and we need to migrate the learndash data which is the LMS plugin, and we have online classes, so some users have made progress in their courses it must be the same on the staging site…
Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan of the migration process, because when you want to start, we need to put the live site on maintenance mode until migration is done, and we don’t want to keep it long under maintenance for the client u know…
Tables from database that required to be migrated.
wp_learndash_pro_quiz_category
wp_learndash_pro_quiz_form
wp_learndash_pro_quiz_lock
wp_learndash_pro_quiz_master
wp_learndash_pro_quiz_prerequisite
wp_learndash_pro_quiz_question
wp_learndash_pro_quiz_statistic
wp_learndash_pro_quiz_statistic_ref
wp_learndash_pro_quiz_template
wp_learndash_pro_quiz_toplist
wp_learndash_user_activity
wp_learndash_user_activity_meta
wp_usermeta
wp_users
wp_wc_customer_lookup
wp_wc_order_stats
wp_woocommerce_order_itemmeta
wp_woocommerce_order_items
We migrated the site using a plugin, I created a backup using WP All in One WP migration, and restored it on a clean WordPress installation, that's how I created the staging site.
The migration was made to change the theme and keep all functionalities. The live site has a custom made theme built by old developers who built as well the custom plugin connected with LearnDash and WooCommerce. We installed Divi theme of the staging site and rebuilt the whole website, we changed some plugins but mainly the main plugins and the custom plugin are still there on the staging site and working. I prefer to migrate all tables, that would cover everything, but would it cause any problem with the staging sites like Plugins/themes problems...
We need to migrate Users, Users metadata, WooCommerce Orders, and anything related to users, and we need to migrate the learndash data which is the LMS plugin, and we have online classes, so some users have made progress in their courses it must be the same on the staging site…
Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan of the migration process, because when you want to start, we need to put the live site on maintenance mode until migration is done, and we don’t want to keep it long under maintenance for the client u know…
Tables from database that required to be migrated.
wp_learndash_pro_quiz_category
wp_learndash_pro_quiz_form
wp_learndash_pro_quiz_lock
wp_learndash_pro_quiz_master
wp_learndash_pro_quiz_prerequisite
wp_learndash_pro_quiz_question
wp_learndash_pro_quiz_statistic
wp_learndash_pro_quiz_statistic_ref
wp_learndash_pro_quiz_template
wp_learndash_pro_quiz_toplist
wp_learndash_user_activity
wp_learndash_user_activity_meta
wp_usermeta
wp_users
wp_wc_customer_lookup
wp_wc_order_stats
wp_woocommerce_order_itemmeta
wp_woocommerce_order_items
We migrated the site using a plugin, I created a backup using WP All in One WP migration, and restored it on a clean WordPress installation, that's how I created the staging site.
The migration was made to change the theme and keep all functionalities. The live site has a custom made theme built by old developers who built as well the custom plugin connected with LearnDash and WooCommerce. We installed Divi theme of the staging site and rebuilt the whole website, we changed some plugins but mainly the main plugins and the custom plugin are still there on the staging site and working. I prefer to migrate all tables, that would cover everything, but would it cause any problem with the staging sites like Plugins/themes problems...