wp_option table error while importing

I was able to solve my own problem, while its was a very struggling effort.If your database is corrupt, but you want to restore your site. Just open your database in a any program like TextEdit, Notepad++ and make sure you copy the basic databases mention here in a new database, that will at least make your website up and running back as it was 🙂

Related Posts:

  1. Delete all post meta except featured image
  2. Set Display Name to first and last name (phpmyadmin SQL Query)
  3. Emojis getting converted to “?”
  4. How to replace values in WordPress DB using phpMyAdmin
  5. Delete all post meta except featured image Using SQL
  6. Accidentally deleted active_plugins portion of the wp_options DB table
  7. WordPress database import: Row size too large
  8. WordPress Database Huge wp_usermeta Table
  9. Connection refused on locahost after importing database?
  10. Changing root password in PHPMyAdmin for WordPress Database when going live
  11. Can’t update WordFence Options, clear data manually
  12. Post Views / Hit Counter Problem?
  13. How to migrate a database from a server to another
  14. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  15. Files on Localhost, Database on Server
  16. Backing up WordPress database and files
  17. Installing local to live WP into subdirectory
  18. Delete user with only subscriber role
  19. Can’t log into wordpress site – I have made a new user and still cant access
  20. Is there any way to monitor a MySQL db and check what has changed?
  21. DB prefix not updating
  22. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  23. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  24. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  25. Is there any defects for using same database prefix in WordPress for multiple sites?
  26. Migrating meta_key and meta_value from old theme to new one
  27. What is recommended data type and encryption type for password in a database
  28. syntax error for changing user role from database
  29. Duplicate database to roll back theme & content changes
  30. WP website showing blank page after moving from subdomain to main domain
  31. How to retrieve user data based on role using SQL?
  32. WordPress character set issue
  33. Missing latest posts and options after DB migration via phpMyAdmin
  34. Check if a database is well installed
  35. Changed meta_key value in structures, now dashboard shows zero users
  36. Options table – where does my values go?
  37. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  38. Checking if Database Table exists
  39. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  40. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  41. Syncing local content with development / staging sites
  42. Export WP database for import using WP-CLI on Vagrant Box
  43. What is the advantage of separating wp_users and wp_usermeta table?
  44. Showing content from another wordpress installation database in the page template loop?
  45. “MySQL server has gone away” since update to 3.8
  46. WordPress page title repeated in SOME pages
  47. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  48. How to correctly add a table to the WordPress MySQL database
  49. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  50. Is it safe to convert tables from MyISAM to InnoDB?
  51. Use one WordPress database with multiple instances of one site
  52. Who is responsible for data sanitization in WordPress development?
  53. How do I properly update the WordPress database password?
  54. wpdb_prepare with multiple or condition
  55. $wpdb->insert is not working
  56. WordPress Install and Database on separate hosting?
  57. Moving a site from a temporary domain to the live domain [duplicate]
  58. What is this in my tables
  59. what is the best way to store user created data?
  60. WP get stuck with a query on MySQL when the site is resumed
  61. Using GROUP CONCAT in my-sql query with wp_usermeta table
  62. How to move the WordPress site Layout from test site to Production site?
  63. Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”
  64. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  65. Retrieve data from the database to table such as comments in the admin control panel
  66. Need to store custom user information (many-many relationsips), preferably not as user meta
  67. charset problem with new custom table
  68. import posts with dutch/special letters
  69. Undefined Variable: mysqli error when connecting to database
  70. How to share plugin created database tables between two WordPress sites
  71. How to connect to a remote database in WordPress?
  72. $wpdb->insert Giving duplicates
  73. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  74. Where is phpMyAdmin inside WordPress?
  75. What can I do when an outside party hacks into my weblog and changes my display name?
  76. Cannot restore wordpress database from sql dump [closed]
  77. WooCommerce: remove sample & dummy data
  78. Is database deleted on clicking “reinstall” button in WordPress updates?
  79. Is my way to change WordPress server is correct?
  80. I cannot find the difference between these wp_capabilities values in wp_usermeta
  81. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  82. WordPress keeps redirecting to localhost
  83. get value from ‘terms’ table
  84. How to rename custom table name programatically in wordpress?
  85. Displaying requested data from a the database in wordpress
  86. How to edit custom table data in frontend
  87. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  88. generate PDF from member information
  89. Help posting values to DB on submit using $wpdb->query
  90. wpdb query to insert images in to post/page gallery
  91. Creating a database in my plugin not working
  92. How to create index (sql) to a meta_key?
  93. Not sure what to do next to optimize
  94. get_user_meta and umeta_id
  95. $wpdb not working
  96. Send data to database after redirect (and popping out of iframe)
  97. Simple email input store in database
  98. $wpdb->insert not working for last select option
  99. How to create a table [closed]
  100. Upload wordpress from localhost to 000webhost