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

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

11 years ago

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

Previous « Magento – “Failed to mkdir” Error

How to use Meta Business Suite: 2024 Guide

Meta Business Suite is nothing but formerly Facebook Business Manager designed to help users manage their presence across Facebook and Instagram seamlessly.…

2 days ago