Title: need help for database error
Last modified: August 30, 2016

---

# need help for database error

 *  [NonTechGuy](https://wordpress.org/support/users/nontechguy/)
 * (@nontechguy)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/)
 * Hi all,
 * I accidentally deleted a table in MyPHPAdmin, and I am having problems accessing
   my WordPress dashboard.
 * The table I accidentally deleted is:
 * wp_mhqc3cxddg_options
 * How could I recover this if I have no backup?
 * Thanks!

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

 *  Moderator [cubecolour](https://wordpress.org/support/users/numeeja/)
 * (@numeeja)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845211)
 * Your hosting company may have a database backup, If you have not already contacted
   them, it is worth asking. They may be able to restore the database to an earlier
   version for you.
 *  [juggledad](https://wordpress.org/support/users/juggledad/)
 * (@juggledad)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845231)
 * As cubecolour said contact your host and hope they have a backup. If they don’t
   then you are in trouble. Without a backup, there is no way to recover it.
 *  Moderator [cubecolour](https://wordpress.org/support/users/numeeja/)
 * (@numeeja)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845259)
 * The site may not be totally unrecoverable without a database backup, but that
   is the best option if there is a possibility that a backup is available. Some
   hosting companies may charge a fee to restore a backup.
 * It may also be possible to recreate the options table and enough of its content
   to get the site back up (some things like plugin options and widgets will unavoidably
   be lost in this case), however this would be beyond the support that can be provided
   on these forums, so if the hosting company can’t help, you might be able to hire
   someone who can attempt to recreate the options table for you at [http://jobs.wordpress.net](http://jobs.wordpress.net)
 *  [juggledad](https://wordpress.org/support/users/juggledad/)
 * (@juggledad)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845268)
 * @cubecolour – Great idea! I hadn’t thought of that and I just went and tried 
   it. it’s actually not that hard.
 * 1) do a fresh install of wordpress to a new DB
    2) export the wp-options table
   from the new DB 3) swap to the old DB and import the wp-options table 4) use 
   phpMyAdmin to edit teh two rows with the option names ‘siteurl’ and ‘home’ to
   match the url of the old site
 * You can now login. The site will default back to one of the twenty-xxxx themes
   but you can go to the theme picker and choose your theme again. You will, of 
   course, have lost any customization that stored anything in the options table.
 *  Moderator [cubecolour](https://wordpress.org/support/users/numeeja/)
 * (@numeeja)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845271)
 * This wouldn’t be hard to someone comfortable with phpMyAdmin, but I wouldn’t 
   suggest that a self-declared non-technical user should attempt this unless they
   are 100% certain that they have a good backup of the database before starting
   and are comfortable with restoring it in case of errors.

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

The topic ‘need help for database error’ is closed to new replies.

## Tags

 * [dashboard](https://wordpress.org/support/topic-tag/dashboard/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [table](https://wordpress.org/support/topic-tag/table/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 3 participants
 * Last reply from: [cubecolour](https://wordpress.org/support/users/numeeja/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/urgently-need-help-for-database-error/#post-6845271)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics