Top Hosting Forum

WebHosting Reviews Forum


How to repair 30GB big crashed database

Virtual Private Server Forum and Dedicated Server Forum - Discussion on dedicated server and VPS issues
Namecheap.com - Cheap domain name registration, renewal and transfers - Free SSL Certificates - Web Hosting

Hosting Forum Description
Virtual Private Server Forum and Dedicated Server Forum - Discussion on dedicated server and VPS issues

How to repair 30GB big crashed database

Postby hostingforum » Wed Nov 21, 2012 10:51 pm

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



Ad: There You can have your forum site-wide banner/text ad for $19 monthly. Contact admin


User avatar
hostingforum
Site Admin
 
Posts: 640
Joined: Fri May 20, 2011 7:58 pm
Location: Czech Republic

Return to VPS & Dedicated Server Forum

Who is online

Users browsing this forum: No registered users and 0 guests

.

cron