Categories: Hostripples Featured

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

HR-ADMIN

Will AI Replace Developers in the Future?

Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…

2 days ago

How To

What is Bot Traffic? Easy Ways to Detect and Block It

Introduction to Bot Traffic Bot traffic refers to visits to a website that come from automated software programs rather than…

2 weeks ago

Windows

Repairing corrupted mysql database !!

HR-ADMIN

You May Also Like

Mysql Database size shows 0 in cPanel

Duplicate MySQL Database

Mysql error : Can’t create new tempfile: ‘*.TMD file

Recent Posts

Will AI Replace Developers in the Future?

What is Bot Traffic? Easy Ways to Detect and Block It

100+ Essential Windows Commands You Can’t Ignore

YouTube Shorts for Beginners: Step-by-Step Guide (2026)

YouTube SEO Secrets That Actually Work in 2026

Resources