How to repair 30GB big crashed database

postcd

Well-Known Member
Oct 22, 2010
721
20
68
Hello, on my cPanel server, vbulletin forum has around 5 million posts, whole database is around 30GB in size. The repair process is interupted.

How to repair, optimise virtually any mysql database size even on weak server? What mysql values to modiffy what software to use so the process goes slowly and safelly untill completion?

Thank you

--
Notes:
Can increasing myisam_sort_buffer_size help speeding repair process?

Automatically repair myisam indexes: Put this in your /etc/my.cnf:
[mysqld]
myisam-recover=backup,force

Check all databases statuses: mysqlcheck -A -F
Repair all databases (may take a long time): mysqlcheck -A --auto-repair

Manual on how to repair corrupt innodb tables here
/http://www.softwareprojects.com/resources/programming/t-how-to-fix-mysql-database-myisam-innodb-1634.html
 
Last edited:

lorio

Well-Known Member
Feb 25, 2004
313
22
168
cPanel Access Level
Root Administrator
Perhaps you state what exactly you are doing and what error message is shown when you're talking about "The repair process is interupted.".