|
Omar Paloma
|
June 21, 2015 at 1:24 pm
Is there a way to merge my development site data with my live site data?
|
|
Dean
|
June 22, 2015 at 12:47 am
Hi,
It kind of depends on the site’s databases.
If the development site is based on the live site and all the new data is purely on the development site, then you should be fine with migrating the dev database to the live one (basically over writing the live database).
If the live has also changed then things get much more difficult. As far as I’m aware there’s no easy way to do this as you will need to manually check and resolve any conflicts (and there will be conflicts). Most likely you will need to create specific SQL scripts to transfer the data over.
A plugin such as WP Migrate DB (https://deliciousbrains.com/wp-migrate-db-pro) might help, but again, I don’t think it has a merge system so it simply over writes the existing database.
Of course, it also depends on what data you’re trying to move. For example, if it’s just EE3 events, you could export them and modify the spreadsheet to remove the existing ones and import it in the new site. EE4 doesn’t have import/export yet.
As always, BACK UP your databases before attempting anything!
|
|
Omar Paloma
|
June 22, 2015 at 1:16 pm
Excellent response! Thanks I was about to upgrade my live site to perform the merge and decided to check first.
My live site is ee3, dev site ee4. I would want to merge my ee3 data to ee4. Are saying that it is not possible to export the participants data from ee3 and import it to ee4 then transfer the entire dev site to my live site?
|
|
Jonathan Wilson
|
June 22, 2015 at 1:32 pm
Hi Omar,
I would recommend installing EE4 on the dev site and migrating EE3 to EE4 before migrating from Dev to Live.
Be sure to deactivate EE3 before installing EE4.
|
|
Omar Paloma
|
June 25, 2015 at 9:52 am
Oh dear Jonathan… ok so if EE4 has no import export how can I merge the data?
|
|
Omar Paloma
|
June 25, 2015 at 9:57 am
Thinking about it, the data on the live Dev is not extensive BUT it would be nice to keep. I definitely don’t want to lose the data on the live sever. I have about 2 events on testing server and about 90 customer entries. Is there no way to port/merge them to ee4 on the live server?
|
|
Josh
|
June 25, 2015 at 12:15 pm
Hi Omar,
As Dean mentioned earlier, we are not aware of a recommended way to selectively merge data from one site to another. The solution that works for most folks is to copy the data in full from one site to another using a plugin like WP Migrate DB Pro.
|
|
Omar Paloma
|
June 25, 2015 at 2:07 pm
SNAG!! I had previously upgraded to ee4 but then downgraded back to ee3. Unfortunately, this installation is recognising my previous ee4 data not my ee3 data. Help.
|
|
Josh
|
June 25, 2015 at 2:59 pm
Hi Omar,
Which version of Event Espresso do you currently have activated? Generally speaking, EE3 cannot read EE4 data, so any details that you can provide will help us to investigate.
|
|
Omar Paloma
|
June 25, 2015 at 5:00 pm
My live site was the current version of ee3 3.1.37.4.P. I disabled it and removed it prior to installing the current version of ee4. However, I had installed ee4 4.5 (originally 4.4.1 then upgraded) in the past. I had problems with it and downgraded to ee3. Now I am trying to upgrade but somewhere in the database there is obviously an ee4.5 flag as it sees ee4.5 but doesn’t see ee3.x The actual message is: Event Espresso has detected event data from version EE4.4.5.p (Core) that can be migrated (updated) to work with version EE4.5.0 (Core).
|
|
Josh
|
June 26, 2015 at 5:52 am
Hi Omar,
You can remove the EE4 data by going to the Maintenance Page’s Reset tab and select the option to delete the EE4 data. The option to delete data will only remove EE4 data and leave the EE3 data intact. As a precaution, please back up your database first.
|
|
Josh
|
June 26, 2015 at 6:13 am
To further the above advice:
The way forward is to (1) remove all the EE4 data but leave all the EE3 data in place, and then (2) re-migrate your data from EE3.
To do (1), you go to EE4’s maintenance page, click the “Reset/Delete Data” tab (which is accessible while Event Espresso is in maintenance mode too), and then click “Permanently Delete All Event Espresso Data”. The button should really be labelled “Permanently Delete All Event Espresso 4 Data” (there isn’t yet an option to delete EE3 tables). This will delete all your EE4 tables, data and wp options but it will leave your EE3 tables, data and options in-place, and it will deactivate EE4 for you.
To do (2), you re-activate EE 4.7.4.p and run the migrations.
|
|
Omar Paloma
|
June 26, 2015 at 5:42 pm
Hasn’t worked. I can see via phpmyadmin that there is data in the table but the reinstallation failed to recognise the existence of this ee3 data
any ideas?
|
|
Josh
|
June 29, 2015 at 8:24 am
Are there any tables in the database that have an _esp_ in their name?
|
|
Omar Paloma
|
July 1, 2015 at 2:26 pm
Hey Josh,
Yes. Here is an example:
wp_esp_checkin
wp_esp_country
wp_esp_currency
wp_esp_currency_payment_method
wp_esp_datetime
wp_esp_datetime_ticket
wp_esp_event_mailchimp_list_group
wp_esp_event_message_template
wp_esp_event_meta
wp_esp_event_question_group
wp_esp_event_question_mailchimp_field
wp_esp_event_venue
wp_esp_extra_meta
wp_esp_line_item
wp_esp_log
wp_esp_message_template
wp_esp_message_template_group
wp_esp_payment
wp_esp_payment_method
wp_esp_people_to_post
wp_esp_price
wp_esp_price_type
wp_esp_promotion
wp_esp_promotion_object
wp_esp_promotion_rule
wp_esp_question
wp_esp_question_group
wp_esp_question_group_question
wp_esp_question_option
wp_esp_registration
wp_esp_rule
wp_esp_state
wp_esp_status
wp_esp_ticket
wp_esp_ticket_price
wp_esp_ticket_template
wp_esp_transaction
wp_esp_venue_meta
|
|
Josh
|
July 1, 2015 at 4:35 pm
You’ll need to remove those before it will try to migrate EE3 data.
|
|
Omar Paloma
|
July 4, 2015 at 3:46 pm
Hey Josh, Jonathan and Dean,
I appreciate your help however I am not comfortable with the advice being offered. I had a chance to look at wp_esp_attendee_meta. It would appear that this table contains my most recent data. There is also a table wp_events_attendee that doesn’t contain the most recent data. If I deleted all of the wp_esp tables I can’t see how my data would be migrated. You explain?
|
|
Omar Paloma
|
July 5, 2015 at 2:07 am
I’ve tried reinstalling – nothing.
Here is some information I hope will be useful: 4.7.6.p
ee_activation_history
4.4.1.1.decaf
2014-09-21 20:17:18
2014-10-08 00:02:32
3.1.36.4.L
unknown-date
4.4.4.p
2014-11-02 22:44:18
2014-11-04 21:44:56
2014-11-04 22:13:32
2014-11-05 12:59:32
2014-11-05 15:48:59
4.4.5.p
2014-11-21 15:09:50
3.1.36.6.P
unknown-date
3.1.36.6.1.P
unknown-date
3.1.37.1.P
unknown-date
3.1.37.3.P
unknown-date
3.1.37.4.P
unknown-date
4.7.4.p
2015-06-25 20:05:13
2015-06-26 22:50:21
2015-06-26 22:58:22
4.7.6.p
2015-07-05 08:00:26
|
|
Josh
|
July 6, 2015 at 7:52 am
Hi Omar,
Since you have EE4 data on this site, you cannot migrate the EE3 data into it. Another option you have is migrate the EE3 data onto another site that has never had EE4 installed on it. EE4 will not merge old EE3 attendee data after there’s already new EE4 data on the site.
|
|
Omar Paloma
|
July 6, 2015 at 2:43 pm
Thank you, Josh.
This sounds very difficult. So far it seems that testing EE4 fully is quite hard. The only way to be certain how it will perform is with live data (there were things I couldn’t work out when I tried the live demo). So while I am happy that I can now proceed with EE4 my testing is now a bit of failure from the POV that I can’t merge my data and I can’t seem to upgrade my live server – seems it’s all there but not able to access it. Never the less I appreciate your trying to help. Unfortunately, either I don’t fully understand, or the assistance is making things worse.
1)Since this data is un-migrated ee3 tables, can I delete all instances of ee4, reinstall ee3 to the latest version then try the upgrade again?
2) if so, not have expertise in how your databases are put together and being a MySQL novice, how, step by step, do I go about deleting all instances/references/tables from ee4?
3) If the above isn’t possible, how do I migrate the ee3 data to another site as you suggested?
4) since ideally I don’t want to run event espresso on separately, after migrating to another site, how do I bring the ee3 data back? Wouldn’t I have to wipe all ee3 and ee4 data from the existing site, somehow copy the ee3 data BACK from the new site and re-migrate?
5)If bringing it back after migrating it out is not possible, can I migrate it to a fresh WP install on a subdomain? if so (not being a WP infrastructure expert, what kind of additional demands would that make on my server?
|
|
Lorenzo Orlando Caum
|
July 7, 2015 at 2:27 pm
Hi Omar, according to what you have shared in your latest reply, you could go to your WP dashboard and then Event Espresso –> Maintenance –> Reset/delete. There are a few options on this page. The last one (bottom of page) will remove Event Espresso 4 data.
I think your overall question is you would like to try out Event Espresso 4 and then merge Event Espresso 3 into that site at a later time.
That won’t work as expected since the migrations would have already run.
Another option is to use a tool like WP Migrate DB Pro to create a testing / development version of your Event Espresso 3 site on a different WP install. Then you could run the migration and try out Event Espresso 4 with some existing attendee and event data.
Then at a later date, you could run the migration on the live site and move to Event Espresso 4.
—
Lorenzo
|
|
Omar Paloma
|
July 9, 2015 at 10:49 am
Thanks Lorenzo. That is almost correct. It’s a long thread but to summarize what actually happened: I tried to follow the instructions (see Dean’s response above June 22) to upgrade my EE3 to EE4 but the upgrade/migration failed. Now I have a split database. I have A new EE4 install with no data AND I have all of my old EE3 tables with data, or at least that is how it appears. If the data is still in EE3 tables why can’t I delete the EE4 installation and all traces of EE4 and retry the upgrade. If not, the failure is not as a result of my actions, that I can see. I will need help getting my data. What can you suggest?
|
|
Lorenzo Orlando Caum
|
July 9, 2015 at 11:03 am
Hi Omar, I recommend using a tool like WP Migrate DB Pro and replace the entire testing site with fresh data from your live site.
At that time, you can try the migration again to the 4.7.x platform for Event Espresso.
—
Lorenzo
|
