Table 'DATABASE.wp_TABLE_options' doesn't exist

  • This error occured after attempting to use the MEDIA TEMPLE WordPress Hosting / Developer Tools / Staging Site / SYNC SITES

    A staging site feature of their hosting environment essentially failed. Right under the sync site button is 30 days of backups by date… of the active site only, not the staging site… no indication otherwise. At any rate we are in a horrible position of having a missing site that they won′t provide support in recovering (they essentially told us to start over). However, when we check the database the fields seem to be their for all site pages/posts.

    When attempting to view site or WP Admin at:
    https://710.bb9.mwp.accessdomain.com/

    this message displays.
    “Error establishing a database connection”

    When viewing the table for options in MyPHP Admin it says:
    Error
    SQL query: Edit

    SHOW INDEX FROM wp_TABLE_options ;
    MySQL said: Documentation
    #130 – Incorrect file format ‘wp_TABLE_options’

    We exported the table (5mb), imported it into a new wordpress install and migrated all site files via FTP following instructions for linking table prefix.Wordpress prompts came up and and it attempted to repair the database, no luck. When looking at import of old database into MYPHP admin, the options table isnt there at all.

    Is it possible to add a new Options table?

    Is it possible to export all tables into a new db with working options table?

    Basically, what is best solution… thanks in advance for any help provided.

  • The topic ‘Table 'DATABASE.wp_TABLE_options' doesn't exist’ is closed to new replies.