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!