MySQL Error No : 1030

[nixsavy]

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.

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.