Knowledgebase

How do I repair a damaged MySQL table, rebuild index or prepare for backup ?

It is always worth trying a repair of MySQL tables before backing them up to shrink the files-sizes and check for inconsistencies in the indices...

from the SSH prompt, change directory to the location of the database
(usually /var/lib/mysql/databaseName)
and execute the MySQL ISAM Check command:
myisamchk -r *.MYI

Add to Favourites    Print this Article

How to Change Service Password? (Views: 2512)

What is PHP? (Views: 2699)

Can you help / migrate my accounts / websites /emails / databases ? (Views: 2594)

How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk. (Views: 3100)

What is MySQL? (Views: 2700)