Repairing corrupted mysql database !!

Sometimes it happens that your database get corrupted due to many reason like it does not get restored properly or server get rebooted while updating database etc…. and you have tried to repair it using phpmyadmin and it does shows that it has repaired but it is not.
Solution :
Login to server with root access
Stop mysql using following command
/etc/init.d/mysql stop
Run following command to check all teh tables in teh database
/usr/bin/myisamchk /var/lib/mysql/databasename/*.MYI
Run following command to repair all teh tables in the database
/usr/bin/myisamchk -r /var/lib/mysql/databasename/*.MYI
Then recheck again using following command
/usr/bin/myisamchk /var/lib/mysql/databasename/*.MYI
Restrart MySql service using following command
/etc/init.d/mysql restart

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

IBM's Blue Cloud Meets Juniper To Alleviate Cloud Computing Adoption Fears

Security and lack of an acceptable SLA are customers' top adoption fears to move to cloud computing . IBM's recent announcements to further advance their cloud computing initiative known as Blue Cloud should help alleviate these fears to some extent. IBM announced their partnership with Juniper for their hybrid cloud initiative to provide secured private cloud with better SLA. IBM also announced new offerings for the cloud - Tivoli storage as service and a new set of cloud management tools to align with what a typical CIO would look for when migrating to the cloud. In addition IBM is pushing some of their existing offerings on the cloud that customers can now use off Amazon's EC2 on pay-as-you-go subscription model . IBM has been experimenting with the concept of a private cloud for a while. One of such experiments included creating a private virtual cloud inside the firewall to deploy some of the regions of SecondLife with seamless navigation in and out of the firewall....
Lire la suite

Implementation of Cloud Computing Solutions in Federal Agencies : Part 1-Introduction

Image
(This post first appeared on "Cloud Musings on Forbes". This series provides the content of a whitepaper I recently authored. A copy of the complete whitepaper is available at NJVC.com starting September 7, 2011.) Introduction Cloud computing is a new approach in the provisioning and consumption of information technology (IT). While technology is a crucial component, the real value of cloud computing lies in its ability to enable new capabilities or in the execution of current capabilities in more efficient and effective ways. Although the current hype around cloud computing has focused on expected cost savings, the true value is really found in the mission and business enhancements these techniques can provide. When properly deployed, the cloud computing model provides greatly enhanced mission and business capability without a commensurate increase in resource (time, people or money) expenditures. Cloud Computing: Changing the Game The use of commodity components, coupled ...
Lire la suite

Dataline launches SOA-R: Cloud Computing for National Security Applications

Image
Last week, Dataline (my company), in collaboration with IBM , Google , Northrop Grumman , Cisco and Great-Circle Technologies , launched an initiative aimed at integrating an end-to-end solution for secure cloud computing. Called Service Oriented Architecture – Real Time (SOA-R), the goal is to provide the benefits of cloud computing and secure ad-hoc mobility in a modular, standards-based implementation framework to public sector organizations. By exploiting the advantages of a service oriented approach, web services and interfaces specific to the national security business domain are being developed and enhanced for deployment from and interface with a cloud computing infrastructure. By doing this, Dataline, in concert with its partners, looks to provide leading edge solutions without the risk typically associated with early adoption of leading edge technologies. Like cloud computing, SOA-R has dual meanings. Whereas cloud computing refers to both a platform and type of application...
Lire la suite