Lost the `wp_options` table: what’s the best way to restore the site?

Uh oh, that’s an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

Related Posts:

  1. What is this JavaScript “require”?
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. get_results using wpdb
  4. How can I make a WordPress database portable and url independent?
  5. wpdb->insert multiple record at once
  6. How to migrate a HTTPS WordPress installation to localhost?
  7. WordPress Connection Pooling
  8. How does $wpdb handle COUNT(*)
  9. Login in WordPress using external database data
  10. How to reset the post ID increment
  11. Shared Members between two different wordpress installations with different databases
  12. Efficiency on displaying random authors based on large database
  13. How to write Hebrew characters?
  14. Error establishing a database connection – with Debug Data
  15. Finding the login page from database?
  16. How to execute mulitple statement SQL queries using $wpdb->query?
  17. Store and Encrypt Contact Form 7 Submissions in Database? [closed]
  18. When and why should I use $wpdb different return types?
  19. Database with mixed collation (utf8mb4 & utf8_general_ci)
  20. WordPress database growing dramatically in size despite adding no new content
  21. Clean database from unused tables
  22. How wordpress accesses its own database
  23. Migrating database / content of non-CMS site to WordPress
  24. Delete all post meta except featured image Using SQL
  25. WordPress doesn’t show all posts in database
  26. Adding new row to wp_post table
  27. Show last modified date of database
  28. Extracting the post_id via the wp_insert_post action (external db query)
  29. How to interact with another wordpress install on same database?
  30. What is the proper way to validate and sanitize JSON response from REST API?
  31. What generates these very slow postmeta queries? [closed]
  32. batch UPDATE autoload value in wp_options table
  33. Saving into post_excerpt or post_content
  34. Maintain user profile data in a non-WordPress database
  35. How to fix the disappearance of the “\” character when updating a post in the database
  36. Data storage for JS app using WP REST API
  37. How to scan barcode and store data into a database [closed]
  38. Fetching values from database for select box
  39. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  40. Setup private content for specific users with daily updates [closed]
  41. fastest replacement DB
  42. Connection refused on locahost after importing database?
  43. When to use custom DB tables or add_option?
  44. Have working sql query… trying to adjust it to use $wpdb
  45. Best host for running large mem and processor intensive WordPress sites?
  46. creating new field on mysql
  47. Does WordPress store the username as a primary key in the database?
  48. Strange characters added to the database
  49. WSOD 3.9.1 – Tried Everything so far
  50. Database Update Required – Update from command-line
  51. Can you refresh ONLY the wordpress adminbar and not the whole page?
  52. Sending posts from Python to WordPress
  53. Problem migrating to localhost
  54. SQL query to set posts in bulk based on the post content
  55. Automate WordPress website setup with prefilled data
  56. Custom search query by category id
  57. How do you render posts from outside wordpress?
  58. Image link issues after importing a database backup to my local web server
  59. multiple wordpress installs w/shared user database but separate content databases
  60. Second ezSQL initialization for MSSQL
  61. Fetch a single row from a custom table for to a given ID
  62. Database create or redirect
  63. Updating seperate database when post attachment is changed
  64. add featured image dialog box disappear
  65. Database structure cheatsheet
  66. White Screen in Home Page
  67. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  68. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  69. How to get a list of articles related to a particular category from my other WordPress website?
  70. Migrate Users From laravel to wordpress
  71. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  72. /wp-admin not accessible after migrating to local host (no plugin issue)
  73. set_transient fails if the value has more than 60.000 characters
  74. Malware in old website – how to migrate?
  75. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  76. error establishing database connection (WAMP + filezilla)
  77. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  78. How do I update a WordPress wp_postmeta meta_value that contains many options
  79. How can I get $wpdb to show MySQL warnings?
  80. About wp database hooks (error establishing connection)
  81. How to display $wpdb->insert_id; value on redirected page
  82. Should I Use only wpdb Class to Write Custom Queries?
  83. Auto populate form fields based on serial input or pull listings from other websites?
  84. How to extract some part of WordPress full source code
  85. Create Tables in WordPress
  86. Error establishing a database connection for some files
  87. Hash user emails in database?
  88. WordPress Failed to Login (DB Error)
  89. Weird characters in title if it contain “ ”
  90. Share WordPress Database
  91. DB access blocked when initializing WP externally
  92. Saving data to database and exporting to excel
  93. Site does not work right, pages not showing up, even for root admin
  94. ERROR: “Table Prefix” must not be empty
  95. How do you build a database-centric site in WP?
  96. One information repeated on multiple locations on one site [closed]
  97. WordPress: Interact with Database Query Data and Login
  98. Showing Error(TAble already exist)
  99. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  100. WordPress database connection failed, while mysql client is working [closed]

Leave a Comment