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

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

DSNLess connection to MS SQL (Views: 1921)

Does your control panel allow for file uploads not using FTP ? (Views: 2488)

How do I create a MySQL database in Cpanel ? (Views: 2163)

How do I add an E-mail Account to Webmin (in Virtualmin) ? (Views: 9028)