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

What are Astutium's primary and secondary nameservers? (Views: 28645)

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

'80004005' Could not use ''; file already in use (Views: 1795)

My CGI script is not working, what permissions do I need to set for them to function properly? (Views: 2310)

Microsoft JET Database Engine error '80040e14', Syntax error in... (Views: 2929)