MySQL Got error 28 from storage engine [Resolved]

The MySQL database backup can be taken using mysqldump command from command line in a Linux server.

Sometimes, the following error may occur while taking database backup

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

Though the error does not provide much information, the issue is related with the disk space on the server.

In this case

1) Login into the server as root user from command prompt.

2) Check the disk usage.

# df -h

3) Even though more than 20% disk space is available, delete some files.

4) Check by taking the database backup again.

In my case even though more than 18% disk space was free, the error occurred. On removing some files, the error was gone.

Hope this helps!

 

Share on Facebook4
Share on Google+3Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn1Share on Tumblr0Digg thisPin on Pinterest0Share on Reddit0Email this to someonePrint this page

About Abhijit Sandhan

Abhijit Sandhan
Loves Linux, Blogging, Traveling, Hiking and sharing knowledge!

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA