Missing MySQL Database Tables

  • Hi Everyone,

    I need advice please. I am running a new WP website, and checked it this morning, and everything was fine. I logged in, created some new pages, but haven’t added content to them.

    I went to log back in tonight, and failed to produce the login page, and instead wanted me to initiate a new WP install.

    There was obviously an issue, so I attempted to get WP to repair tge MySQL database, using FTP to add the following to my “wp-config.php” file :
    define(‘WP_ALLOW_REPAIR’, true);

    I then attempted to log into WP with this URL :
    “https://www.yoursite.com/wp-admin/maint/repair.php” but with my own domain name. WP then asked me if I wanted to “repair” or “repair and optimize” the database. I chose “repair”, which failed with a report telling me to post the following here :

    wp_users: Table ‘db1129360_lproj.wp_users’ doesn’t exist
    wp_usermeta: Table ‘db1129360_lproj.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘db1129360_lproj.wp_posts’ doesn’t exist
    wp_comments: Table ‘db1129360_lproj.wp_comments’ doesn’t exist
    wp_links: Table ‘db1129360_lproj.wp_links’ doesn’t exist
    wp_options: Table ‘db1129360_lproj.wp_options’ doesn’t exist
    wp_postmeta: Table ‘db1129360_lproj.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘db1129360_lproj.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘db1129360_lproj.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘db1129360_lproj.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘db1129360_lproj.wp_termmeta’ doesn’t exist
    wp_commentmeta: Table ‘db1129360_lproj.wp_commentmeta’ doesn’t exist

    I have also tried disabling all plugins via FTP, but this hasn’t helped.

    I have also double-checked (again with FTP) that the database credentials in “.htaccess” are correct.

    This is a major blow for me, and I don’t know what to do next. Can anyone offer any assistance please? My website is at https://www.lprojects.com.au/

    My thanks for taking the time to read this post.

    Kind regards,
    David

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator t-p

    (@t-p)

    First, check with your hosting provider if the db server having problems.

    Thread Starter webinate

    (@webinate)

    Hello Tara,

    Thanks for getting back to me so quickly – I’m amazed and impressed!

    Before I logged this issue with you guys at wp.org, I emailed a support request to my hosting provider. It will be some hours before I get a response from them, but I’ll wait for that before I get back to wp.org.

    Thank you again.

    David

    i got the same same problem with my dbs. my host tried and failed to restore the db connections. any please will be appreciated. sir did you get the solution to this problem?

    Moderator t-p

    (@t-p)

    @favored,
    If you noticed, this is a rather old (9-month!) thread ??

    If the troubleshooting already posted made no difference for you, then, as per the Forum Welcome, please post your own topic. That way you stand a good chance of getting the assistance you want.

    I’m closing this thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Missing MySQL Database Tables’ is closed to new replies.