Repair MySQL Tables

 
|

Repair MySQL Tables

 

How to Repair MySQL Tables ?

1. Login on server
2. Type next linux command in your mysql folder with MYI files :

myisamchk -r –sort-index –analyze *.MYI

folder ex: /var/lib/mysql/yourdatabase/

*NOTE:
- DO NOT TYPE ANYTHING BEFORE BACKUP DATABASE!
- If you request warnig about table damage use in in phpMyAdmin for repair this:

REPAIR TABLE `tbl_name’

Tags: ,
Posted under Bookmarks, Hosting, Linux, MySQL |

Post a Comment

Kyla Ebbert Playboy Pictures »
« Optimize MySQL Tables


We use third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you.