|
Adam
|
August 28, 2024 at 5:43 am
Hello,
We have had some server/worpdress plugin issues which has wreaked havoc for our event espresso data.
The WordPress installation has been recovered and a database backup from 48 hrs ago. As a result we are missing orders in the current recovered installation over the past 3 days.
I have been given access through PHPMyadmin to a database backup which holds the missing data. I need to export the below registration data (or as much as we can) so we can view it in excel and be able to contact customers who have registered paid that we currently have no data for in the installation.
Registration details
– Name, phone, email, address etc
– event name / date of event / venue etc
– ticket name / price
– reg date / time
– transaction details
– questions for primary registrant
– questions for additional registrant
is it possible to query the database using phpMyAdmin to achieve something / anything like this? We desperately need to access the missing 3 days of data in some sort of readable / understandable format.
Many thanks in advance.
|
|
Rio
|
August 28, 2024 at 7:17 am
The WordPress installation has been recovered and a database backup from 48 hrs ago. As a result we are missing orders in the current recovered installation over the past 3 days.
IT Would be easier to create WP on local machine or another WP on your server, then restore the backup you have. Then after you restore it. Download the data you need as CSV?
https://eventespresso.com/wiki/how-to-export-registrations-to-csv/
If you look on the database, there’s a lot of table you need to join to get the data you need.
Querying data through the EE object model is much easier though
https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/using-ee4-model-objects.md
But as i mention, the best approach here is through restoration of the DB to a local WP or another WP on your server.
Let me know if there’s problem with that approach.
Can you also share what do you plan to do with the data? are you going to import it back? Can you give us the background on what happen on your site? did you had a fresh state of DB after you experience server/worpdress plugin issues which has wreaked havoc for our event espresso data. then you plan to combine the fresh state to your backup DB? Those are just our speculation. But if you can give more context, it would be great
thanks
|
