|
Phil Evans
|
July 16, 2018 at 3:48 am
Hi,
We’re in the process of adding new features to a site which includes Peepso Learndash and other plugins.
We have staging and production environments.
We’re testing all the new features and plugins on our staging server.
We now need to migrate all our EE data from production to staging ready to clone staging back to production with he new features.
Is there a way we can export only our EE data and import it into staging? We can’t use DB Migrate Pro as it overwrites a lot of the new features and and pages we have created so we need to be selective and only pull through EE data.
Thanks
Regards
Phil
|
|
Josh
|
July 16, 2018 at 7:04 am
Hi Phil,
There’s a way, but it’s prone to error because anything event-related & attendee-related stored in the wp_posts table will need to be manually merged & conflicts will need to be resolved wherever you have different posts in the sites` wp_posts table that have the same IDs.
What you might be able to do instead is copy over any new tables added by the new plugins, and then use the built in WordPress exporter/importer to import your new pages. You could try that on a third site to see how that goes first.
|
|
Phil Evans
|
July 16, 2018 at 7:10 am
Thanks Josh.
Before I try copying tables and files over, I tried using the WP exporter and importer. It looks to pull through events data, but misses out events dates. Is there anyway I can avoid missing out the dates?
Thanks
Regards
Phil
|
|
Josh
|
July 16, 2018 at 7:46 am
Hi Phil,
You’re not going to be able to rely on the WP exporter for migrating EE events to another site.
|
|
Phil Evans
|
July 16, 2018 at 7:56 am
Hi Josh,
Couldn’t we just export all of the EE tables, structure and data, from production
then drop all the corresponding EE tables on staging and then import the structure and data into staging?
If I’m not mistaken, all of the EE tables have wp_esp_ table prefixes?
With thanks
Regards
Phil
|
|
Josh
|
July 16, 2018 at 8:10 am
You cannot because you’ll have mismatches between the event & attendee data stored in the wp_posts table and their related data stored in the wp_esp_ tables.
For example, let’s say on the staging site, you have a new page with post ID 123456. However, on the production site, you have an event with post ID 123456. If you only import the _esp_ tables over to staging, there will not be an event with post ID 123456, and worse yet, you’ve got a page with that same ID on staging.
|
|
Phil Evans
|
July 16, 2018 at 8:20 am
OK, thanks.
Looks like we’ll have go with your other suggestion
What you might be able to do instead is copy over any new tables added by the new plugins, and then use the built in WordPress etc.
Trouble is we may encounter similar issues with the other plugins.
With thanks
Regards
Phil
|
|
Josh
|
July 16, 2018 at 8:47 am
You’ll definitely need to check the new plugins to see if they record data to the wp_posts table, and if they do, there will be some conflicts to resolve.
|
