|
sbxmedia
|
April 17, 2013 at 4:49 pm
Hello, I have been setting up EE on a temporary address and will be integrating it with my real site in the near future. Apart from registration key and moving the plugins, what database tables would I need to move across? As well, do any of the EE plugins effect non EE tables (like users). Would there be any other considerations I should think about in doing this without issue?
The reason I ask is I have to decide on cleaning out and installing my current 3.1 installation to replace it with 4.0 and then build out the event tool (only to move it when I am done) or just install 4.0 on the final address/live site and do it there.
I know it seems like this is all a bit overcomplicated but we are in the middle of a site redevelopment and the event tool can be used at the temporary address before the website is completed and then when we launch the new site we wanted to move it all over. If the transfer is simple I will continue to build 4.0 on the temporary address.
|
|
Dean
|
April 18, 2013 at 1:38 am
Hi Brian,
The move should be a simple one. Event Espresso uses it’s own tables for most of the data, however there is some data in the general options table. As far as I can tell this is data that will be added when the plugins are activated and some payment gateway settings, so nothing too major.
All the Event Espresso tables are marked *_events_X where * is your database prefix and X is the table name.
The other table that has data is the users table, but only if they are registered with the site (via WP User Integration add on).
Obviously the pages and posts created with EE are in the posts table. If you have just had the core 4 pages created then it shouldnt be any need to move these as the plugin will recreate them on saving the settings after activation.
4.0 will need a fresh or clean database, as it cannot use the 3.1.X database structure.
As im sure you are already aware, but I will say for the record, backup your sites databases before doing anything!
|
