Support

Home Forums Event Espresso Premium Database Question

Database Question

Posted: January 31, 2025 at 4:01 pm

Viewing 1 reply thread


Matt Shane

January 31, 2025 at 4:01 pm

Hi there-
We are doing a site redesign so will move the live site to a dev site to work on. When we move it back to live the EE portion of the dev site will be dated since the current site will still be live taking registrations. Is there a way to simply do an export import of the current database at the time we are ready to go back to the live site so the EE portion of the site is current?

Thanks!


Tony

  • Support Staff

February 3, 2025 at 9:08 am

Hi there,

Not currently.

I’m assuming the new site is going to be use a page builder?

A lot of the EE data within the site are stored as custom post types and we then use the ID of those in custom tables. So the problem with the above is you can’t just copy the data over becuase anything you do within a page builder will store rows in the wp_posts tables and will then be lost, you’ll either lost the page builder changes or EE data wont match up (the ID’s wont match).

The way I’ve advised doing this in the past is to…

1. Copy the site to your dev site and make the changes there, you have some ‘live’ data you can work with there.

2. When ready for the move, put the LIVE site in maintenance mode to stop registrations for a little.

3. Copy the current LIVE site to a NEW dev/staging instance.

4. IF using a page builder, many have an export feature… so use that and export the new designs from the DEV site to the DEV SITE 2. Now you’ll have the live site with the new changes.

5. Export that site to replace the live site. (Make sure you have a backup of the live site before doing this, just to be safe)

Viewing 1 reply thread

You must be logged in to reply to this support post. Sign In or Register for an Account

Event Espresso