Where and how to add table within our Multi-db installation?

Hi Support-Team,

obviously our database is missing an important table to operate hazzlefree. The following message was displayed

The wp_iayq_13_comments table is not okay.

It is reporting the following error:

Table ‘bestofv2_c5.wp_iayq_13_comments’ doesn’t exist.

WordPress will attempt to repair this table…

Failed to repair the wp_iayq_13_comments table.

Error: Table ‘bestofv2_c5.wp_iayq_13_comments’ doesn’t exist

Am wondering would it be enough to create two tables named

wp_iayq_13_comments

and a second one named

bestofv2_c5.wp_iayq_13_comments

BUT

in which database? Perhaps in the .global one or in another one? And how many fields would I have to create within those tables? Can I name the fields anyhow?

Please be so kind forward your professional advice.

Big thank you in advance.

Cheers

Prinz

  • Ash
    • WordPress Hacker

    Hello @prinz

    I hope you are well today and thanks for asking the question.

    Multi DB is a complex plugin, and it’s always recommended to hire a developer to setup this plugin.

    Please note that, when it says bestofv2_c5.wp_iayq_13_comments it doesn’t mean that it’s another table. It means the table name is wp_iayq_13_comments and the db name is bestofv2_c5. So, the wp_iayq_13_comments table in bestofv2_c5 doesn’t exists.

    If this is the only issue, you can simple export a comment table and import into that database. Otherwise, start from scratch is the best option.

    Cheers

    Ash

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.