Error establishing a database connection

  • Lee Beetles

    (@lbeetles)


    11 years, 3 months ago

    Hi i am getting an error when trying to load my site “Error establishing a database connection”

    And when i go to the admin i get the following:

    wp_usermeta: Table ‘wordpress_e0.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘wordpress_e0.wp_posts’ doesn’t exist
    wp_options: Table ‘wordpress_e0.wp_options’ doesn’t exist

    I have checked on my server and i have the .frm files for each but there are no .MYD or .MYI files.

    How can this be rectified?

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

    (@catacaustic)

    11 years, 3 months ago

    Normally when this happens it means that there’s been some corruption in your database, and you’ll need to restore from backups.

    You do have backups, don’t you? 😉

    Thread Starter Lee Beetles

    (@lbeetles)

    11 years, 3 months ago

    Thanks for the reply.

    These files are from a backup.

    catacaustic

    (@catacaustic)

    11 years, 3 months ago

    If the other required files aren’t there then there’s not much you can do. If they are gone and not backed up somewhere, they are gone for good.

    This is one reason that I always try to recommend doing an SQL dump for backups instead of backing up the database files. MySQL can be a bit funny about exchanging files sometimes, so I’ve always found it a much safer option to export and import SQL rather then the raw files.

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

The topic ‘Error establishing a database connection’ is closed to new replies.