Purchase Linux CDs / DVDs / Flash Drives at OSDisc.com

Welcome to Our Community

While Linux.org has been around for a while, we recently changed management and had to purge most of the content (including users). If you signed up before April 23rd, 2017 please sign up again. Thanks!

MySQL Error No : 1030

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

  1. nixsavy

    nixsavy Guest

    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.
    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.

    #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.

    (Log in to hide this advertisement)

    Identify if any table corrupted

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

    #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.

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

Share This Page