Support

Home Forums Event Espresso Premium Which table contain default and custom messages? Questions?

Which table contain default and custom messages? Questions?

Posted: November 3, 2018 at 5:13 pm


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

  • Support Staff

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.

The support post ‘Which table contain default and custom messages? Questions?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  raffy 1 month ago ago

Topic Tags

Notifications

This topic is:
pending
Do NOT follow this link or you will be banned from the site!