{"id":1792,"date":"2008-10-20T02:51:41","date_gmt":"2008-10-20T02:51:41","guid":{"rendered":"https:\/\/www.amitbhawani.com\/blog\/?p=1792"},"modified":"2008-10-20T03:00:02","modified_gmt":"2008-10-20T03:00:02","slug":"reinstall-wordpress-checkrepair-database-tutorial","status":"publish","type":"post","link":"https:\/\/www.amitbhawani.com\/blog\/reinstall-wordpress-checkrepair-database-tutorial\/","title":{"rendered":"Reinstall WordPress Check\/Repair Database Tutorial"},"content":{"rendered":"

\"WordpressDo you feel that database your blog is running on is corrupted and cannot be fixed? The best option to make sure that your database is working perfectly is to check out the database and then repair if it you find any problems in it. You can use these options when you feel that your blog is taking a lot of time to load and there may be some database problems in this, the blog was hacked<\/a> and you need to restore the blog because you didnt take a scheduled backup of your posts<\/a>. You have used several plugins on your blog, which when deactivated have added many errors on your wp-admin page, then its time to implement the following tutorial and give your blog a new life.<\/p>\n

Login to your Cpanel > MySQL Databases :
\n\"Databases
\nClick on the options under the Manage Databases where you can either Check out the Databases or else Repaid the Database, click on any of these options to check and repair all the errors.
\n\"MySQL<\/p>\n

If this does not still repair your blog and you still find many problems in your wp-admin, then the next best option would be to Reinstall your blog completely.<\/p>\n

Things to Note before Uninstalling your Blog :<\/strong> Before you uninstall your complete its very important to take a back up of the following –<\/p>\n

    \n
  1. Your DataBase Backup – Login to your Cpanel, Under the Files Menu you will find the Backup’s option, click on it
    \n\"Backup
    \nNow under this you will find multiple options like Full Backup, Database Backup, Scheduled Backups out of which you need to select the Database Backup and download your blog’s database to make sure you can restore it at anytime, and also a full copy of Home Directory which can also be useful in case you are not able to sucessfully reinstall the blog.
    \n\"Full<\/li>\n
  2. If you host all your Images in a separate folder of your home directory, you need to download all the images to your local pc because while you install the wordpress blog, it can also remove all the subfolders under it and you can loose all the images you have posted within the articles.<\/li>\n
  3. The next step would be to take a complete backup of all your posts, pages, comments, custom fields, categories, and tags which are the most important data on your blog because it would be hard to restore all this stuff without a proper format and a backup file to restore.
    \n    \"Export<\/a>
    \nYou can export all the posts or only for a specific author and click on Download Export File.
    \n\"Download<\/li>\n
  4. Next you should download all the wordpress currently active theme & plugins because once you reinstall your blog all these files will be deleted and you can find just the default themes and plugins. Hence a local copy download is better because you can quickly upload them once the blog is reinstalled.<\/li>\n
  5. Now you can login again to your Cpanel>Fantastico>Wordpress and Uninstall your wordpress blog and then again reinstall it. Then you need to again setup your ‘.htaccess’ file and setup Permalinks. Once done login to your wordpress blog > Manage > Import and then Select ‘WordPress’ option which will ‘Import posts, comments, custom fields, pages, and categories from a WordPress export file.’ and you are done.<\/li>\n<\/ol>\n

    All your posts, and all your data is restored back, upload your theme & plugins back to their respective folders and then upload the Images back to their previous location. Once everything is done you should check out broken links<\/a> on your blog to make sure you dont lose any visitors who end up on your error pages<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Do you feel that database your blog is running on is corrupted and cannot be fixed? The best option to make sure that your database is working perfectly is to check out the database and then repair if it you find any problems in it. You can use these options when you feel that your […]<\/p>\n","protected":false},"author":1,"featured_media":18637,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[376],"tags":[],"class_list":{"0":"post-1792","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"entry"},"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Wordpress-Database-Security.png?fit=180%2C106&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":29,"url":"https:\/\/www.amitbhawani.com\/blog\/install-phplinkdirectory-script-tutorial\/","url_meta":{"origin":1792,"position":0},"title":"How to Install Phplinkdirectory Script – Tutorial","author":"Amit Bhawani","date":"June 10, 2007","format":false,"excerpt":"There are literally around 1000+ web directories running on phplinkdirectory and iam being consulted by many people who are confused how to install this script on their domains. So instead of teaching each and everyone (though i have taught it to many people), iam posting a complete tutorial here on\u2026","rel":"","context":"In "How to Guide"","block_context":{"text":"How to Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/step1.jpg?fit=471%2C434&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3757,"url":"https:\/\/www.amitbhawani.com\/blog\/move-wordpress-blog\/","url_meta":{"origin":1792,"position":1},"title":"How to Transfer a WordPress Blog from One Host to Another","author":"Amit Bhawani","date":"May 11, 2009","format":false,"excerpt":"Do you want to Transfer a Wordpress based blog from one web hosting company to another one? Then you might find this tutorial helpful because we are going to actually transfer a website and recommend you the most important steps which should be taken care of while moving the website.\u2026","rel":"","context":"In "How to Guide"","block_context":{"text":"How to Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/how-to\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5324,"url":"https:\/\/www.amitbhawani.com\/blog\/schedule-blog-database-backup-files-data\/","url_meta":{"origin":1792,"position":2},"title":"Schedule Blog Database Backup Files & Data","author":"Amit Bhawani","date":"August 21, 2009","format":false,"excerpt":"You cannot always rely on your Web Hosting Company for your Blog's Data & Files hosted in your hosting account because at times when there is a Hard Drive Failure you can lose everything ranging from your files and the database along with complete emails wiped off which is when\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Blog Backup Schedule","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2009\/08\/Blog-Backup-Schedule-150x150.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":154,"url":"https:\/\/www.amitbhawani.com\/blog\/wordpress-23-upgradation-problem\/","url_meta":{"origin":1792,"position":3},"title":"WordPress 2.3 Upgradation Problem","author":"Amit Bhawani","date":"November 4, 2007","format":false,"excerpt":"I was just reading a blog and found tags option on the sidebar which made me search for the best tags plugin, but when i searched a lot on it i found the latest wordpress 2.3 version has the Tags feature inbuilt in it. Now the time was to login\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/wordpress-2.3-problem.jpg?fit=446%2C476&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6376,"url":"https:\/\/www.amitbhawani.com\/blog\/wordpress-blog-backup-plugins-tools-tutorials\/","url_meta":{"origin":1792,"position":4},"title":"WordPress Blog Backup Plugins Tools & Tutorials","author":"Amit Bhawani","date":"October 12, 2009","format":false,"excerpt":"You have been blogging from a long period and you have been making thousands of dollars from your blog but what about the security of your this money making machine? Iam not taking about any other security but the important content you have written everyday, the thousands of comments you\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Wordpress-Backup-Tools-Plugins.jpg?fit=500%2C275&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1507,"url":"https:\/\/www.amitbhawani.com\/blog\/bsnl-telephone-directory\/","url_meta":{"origin":1792,"position":5},"title":"BSNL State Wise Telephone Directory","author":"Amit Bhawani","date":"September 26, 2008","format":false,"excerpt":"BSNL is India's biggest telecom service provider which offers everyone with a free online landline phone numbers search feature where in you can access the complete landline numbers database online without paying any access fees. Generally telecom service providers charge you for accessing their database but BSNL has kept all\u2026","rel":"","context":"In "Tech News"","block_context":{"text":"Tech News","link":"https:\/\/www.amitbhawani.com\/blog\/category\/tech-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/1792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/comments?post=1792"}],"version-history":[{"count":0,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/1792\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media\/18637"}],"wp:attachment":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media?parent=1792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/categories?post=1792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/tags?post=1792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}