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

You May Also Like

Mysql Database size shows 0 in cPanel

Some times , database size doesn't update in Cpanel . You can check it through Cpanel===> MySQL database , it shows database size “zero” even if there is available database data. You should follow below steps to resolve this.==============================================root@server [#] vi var/cpanel/cpanel.configand search for following line.disk_usage_include_sqldbs=0 ( set it to 1 instead of 0…

Duplicate MySQL Database

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

If you are getting error like Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it.Solution : You need to just run below command on the shell.# myisamchk -r -f tables.MYIThats all.

Tags: $1 web hosting1 dollar hostingBanned websitecheap hostingcheap web hostingcpanel hostingcpanel web hostingdollar web hostinghostrippleslow cost web hostingMysql linuxMysql Securityweb hostingweb hosting cheap

13 years ago

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

Previous « Magento – “Failed to mkdir” Error

Leave a Comment

Recent Posts

Digital Marketing

How to Get More Customer Reviews That Build Trust and Sales?

Customer reviews have become one of the most influential factors in modern buying decisions. Before choosing a product, service, or…

2 days ago

Digital Marketing

Why Micro-Influencers Matter: How Small Creators Drive Higher Engagement and ROI

In today’s digital landscape, consumers trust people more than brands. Traditional ads are often ignored, celebrity endorsements feel scripted, and…

1 week ago

SEO

2026 SEO Roadmap: Skills Every Digital Marketer Must Have

Introduction: SEO in 2026 Is No Longer Optional—It’s Strategic Search Engine Optimization in 2026 has evolved far beyond keywords and…

2 weeks ago

Hostripples Featured

Website Affirmations for 2026: Build, Grow, and Succeed Online

With 2026 just days away, it’s time to reimagine your website’s future. Hostripples encourages businesses, creators, and entrepreneurs to begin…

1 month ago

Hostripples Featured

Cron Jobs: Automate Everything While You Sleep

Cron Jobs – The Unsung Heroes Think of cron jobs as the unsung heroes of your server — capes optional,…

1 month ago