Database ServerMySQL

How To fix MySQL 1030 Got error 28 from storage engine error

While performing various MySQL database operations like create, backup, etc., you may run into the below error message

1030 Got error 28 from storage engine' when trying to dump tablespaces

Though the error does not provide much information, the issue is mostly related to the disc space on the server.

To resolve the problem, follow the below steps:

1) Login into the server as a root user from shell.

2) Check the disc space usage.

df -h

3) If less than 20% of disc space is available, then delete some files. Make sure a minimum of 20% free disc space is available.

4) Remove unnecessary files from the tmp partition.

5) Re-try by performing the database operation again.

Hope this helps!

Related Articles

Back to top button