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:
- Delete all post meta except featured image
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Emojis getting converted to “?”
- How to replace values in WordPress DB using phpMyAdmin
- Delete all post meta except featured image Using SQL
- Accidentally deleted active_plugins portion of the wp_options DB table
- WordPress database import: Row size too large
- WordPress Database Huge wp_usermeta Table
- Connection refused on locahost after importing database?
- Changing root password in PHPMyAdmin for WordPress Database when going live
- Can’t update WordFence Options, clear data manually
- Post Views / Hit Counter Problem?
- How to migrate a database from a server to another
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Files on Localhost, Database on Server
- Backing up WordPress database and files
- Installing local to live WP into subdirectory
- Delete user with only subscriber role
- Can’t log into wordpress site – I have made a new user and still cant access
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
- Is there any defects for using same database prefix in WordPress for multiple sites?
- Migrating meta_key and meta_value from old theme to new one
- What is recommended data type and encryption type for password in a database
- syntax error for changing user role from database
- Duplicate database to roll back theme & content changes
- WP website showing blank page after moving from subdomain to main domain
- How to retrieve user data based on role using SQL?
- WordPress character set issue
- Missing latest posts and options after DB migration via phpMyAdmin
- Check if a database is well installed
- Changed meta_key value in structures, now dashboard shows zero users
- Options table – where does my values go?
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Deleting WordPress posts and media files based on author via MYSQL database
- Database table prefix different between wp-config.php and in database
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Why is my database import losing text widget data?
- Does dbDelta delete columns as well?
- Insert data in database using form
- Long option names fail silently?
- Upload files – total size limit – WordPress/Contact Form 7
- Relationship between performance and database size
- Scheduling posts in database
- How Do I Merge Categories With phpMyAdmin
- Size article thumbnails and retrieve them directly from database
- Should I be able to run two different “close” code versions of wordpress with the same DB
- Need of separate security plugins for both root and subfolder sites WordPress?
- Escaping / encoding data before insert into a database?
- how to store arrays into a database
- Error: SELECT SQL_CALC_FOUND_ROWS
- Where are WP_Errors Saved
- Error establishing database connection – high traffic?
- Populate dropdown from database
- wordpress ‘database update required’ loop after update
- Database Table for customer user
- How to Access wp_usermeta Data Immediately After a New User is Created
- Cleanup: best way to remove WooCommerce comments from the wp_comments table
- Use same database on main domain & sub domain
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- Why user_pass column in wp_users table is varchar(64)
- Reinstalling wordpress from database breaks the site
- how to count click tab menu and insert to database
- Trouble running $wpdb->query() with last_insert_id
- Using $wpdb | checking entered email against existing emails in db
- wp-cli: Error establishing a database connection: undefined constant DB_USER
- Woocommerce – Check product stock availability from external database
- Get results from wordpress data custom table
- Outputting query results
- Help With a Large WordPress Based MySQL Database on Shared Hosting
- Creating and Using Tables in the WordPress Database
- Compare User meta_value with Product meta_value
- How to insert a value to decimal type field using wpdb->prepare?
- Sql query to get all metadata for a post
- Where do I put my create_new_table function()?
- How to import products in host instead of database on wordpress?
- Having all “non-PHP” files on a different server
- “wordpress error in establishing database connection” and missing tables
- get_option() does unserialize and don’t remove \
- Want to update value in database. But it says update() on null
- Merging development site with live site
- Checking if the data already exsis in the wp database – custom plugin
- live site do not update after importing sql database
- Transforming an wp_options database array into a javascript obect?
- How can I retrieve data from alternate database using wpdb class?
- Database connection close
- WordPress Database Charset/Collate
- User accounts for saving form data?
- Trying to edit a WP site locally using MAMP
- How to delete field using WPDB?
- Log IP of users who click a button? [closed]
- DROP TABLE IF EXISTS `wp_options` error?
- Server database problem
- Best way to search and replace within serialized database strings?
- Order of search results based off of a backend custom field and also in alpha order
- How to find fresh (last modified) and sql backup?