The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to repair 30GB big crashed database

Discussion in 'Database Discussions' started by postcd, Nov 21, 2012.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    621
    Likes Received:
    6
    Trophy Points:
    18
    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
     
    #1 postcd, Nov 21, 2012
    Last edited: Nov 21, 2012
  2. lorio

    lorio Well-Known Member

    Joined:
    Feb 25, 2004
    Messages:
    243
    Likes Received:
    3
    Trophy Points:
    18
    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.".
     
  3. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Is the whole database corrupt OR few tables ?
     
Loading...

Share This Page