MySQL Error No : 1030

Discussion in 'Database' started by nixsavy, May 28, 2013.

  1. nixsavy

    nixsavy Member

    Messages:
    65
    Likes Received:
    17
    Trophy Points:
    8
    If website stop working and give error no. 1030 as below then it typically indicates a lack of available disk space, table crash due to this mysql is unable to write on server.
    Code:
    MySQL Error No : 1030
    
    MySQL Error : Got error 28 from storage engine
    To solve this login to server and check the /tmp, /var or the partition the MySQL databases are stored that partition is not full. If it is full then add additional space or remove existing files to ensure disk space is available. Check partion usage with df command as below.

    Code:
    #df -h
    If disk space is ok but website is still not working then repair mysql database or tables. You can repair databases with command myisamchk.

    Identify if any table corrupted

    Change directory to mysql databases and choose database, we are supposing that mysql stored in /var.


    Code:
    #cd /var/lib/mysql/database-name
    
    #myisamchk *.MYI >> /tmp/myisamchk_log.txt
    When you redirect the output of myisamchk to a temporary file, it will display only the corrupted table names on the screen. The /tmp/myisamchk_log.txt file will contain information about all the tables.

    Repair the corrupted table

    If you find any corrupted table then repair with myisamchk using -r option as below, and make sure mysql service should stop.

    Code:
    #myisamchk -r corrupted-tableName.MYI
    
    Now website should working fine.

Share This Page