|
raffy
|
November 3, 2018 at 5:13 pm
I am running:
Event Espresso 4.9.69.p
Wordpress 4.9.8 MU subdirectory
I am setting up another site within the one wordpress mu install. I want to use the same EE4 questions/question groups and custom messages.
Which tables do I copy to the the new database?
Are these the only tables, I need to copy?
Where nn is the site id in the multisite
ip_nn_esp_message
ip_nn_esp_message_template
ip_nn_esp_message_group
ip_nn_esp_question;
ip_nn_esp_question_group;
ip_nn_esp_question_group_question;
ip_nn_esp_question_option;
What is the best way of copying it (i.e. phpmyadmin import table to target database exported from origin database after dropping original records of the target table)?
|
|
Josh
|
November 5, 2018 at 12:15 pm
Hi Raffy,
For message templates, you would not actually copy over ip_nn_esp_message, because that’s a log of messages that were sent. You would export/import
ip_nn_esp_message_template
ip_nn_esp_message_group
and also any rows from _esp_extra_meta that have Message_Template_Group in the EXM_type column.
For questions & question groups (and values), what you’ve listed is correct.
Usually if you export with phpmyadmin, it will add a “DROP” table statement to the export file so you shouldn’t need to drop tables before importing.
|
|
raffy
|
November 6, 2018 at 5:37 am
Thank you.
|
