Database Repair Problems

  • basska

    (@basska)


    5 months ago

    Hi, I have attempted a repair on my database after encountering an ‘Error establishing a database connection’ page that has locked me out of wordpress editor and accessing our website. The repair has come up unsuccessful and has directed me to find answers here as to how to fix the following issues:

    wp_users: Table ‘forgepre_mainsite.wp_users’ doesn’t exist
    wp_usermeta: Table ‘forgepre_mainsite.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘forgepre_mainsite.wp_posts’ doesn’t exist
    wp_postmeta: Table ‘forgepre_mainsite.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘forgepre_mainsite.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘forgepre_mainsite.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘forgepre_mainsite.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘forgepre_mainsite.wp_termmeta’ doesn’t exist

    Any help/pointers would be appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @basska,

    The above points the mentioned tables are missing. Could you please check by accessing the database to ensure the listed tables are indeed present?

    If the tables are present in the database, then most probably the $table_prefix is incorrect inside the wp-config.php file.

    You’ll need to update the $table_prefix variable in the wp-config.php with correct table prefix.

    I hope the above helps in moving forward.

    Kind Regards,

    Nithin

    Thread Starter basska

    (@basska)

    Hi, I can’t see the above tables in the database but I am also not 100% sure where I should be looking for them. Do you have any ideas?

    If they are not present, how should I go about making them present in the correct way?

    Thank you.

    Hi @basska

    At this point, it will be good to speak with your hosting support and ask is there any backup of the site that can be restored. For example from 2 days ago or from last week, depending on how many changes you have made during that time, and before this happened:

    I have attempted a repair on my database after encountering an ‘Error establishing a database connection’

    If this is some WooCommerce site, it will be good to compare email dates with orders to not lose any orders from the database when you restore the backup from a specific date.

    Kind Regards,
    Nithin

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Tags