Home > MySQL > MySQL – ERROR 1030 (HY000): Got error 28 from storage engine

MySQL – ERROR 1030 (HY000): Got error 28 from storage engine

Problem:
Got this error when trying to restore a database.
ERROR 1030 (HY000): Got error 28 from storage engine

Solution:
Turns out that I was running out of space on /var partition where mysql is. The database I was restoring takes up about 3 GB, 1.1 GB was not enough. So the restore starts but does not end.

user@computer$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1      19G  3.1G   15G  18% /
tmpfs                 2.0G     0  2.0G   0% /lib/init/rw
udev                   10M   64K   10M   1% /dev
tmpfs                 2.0G     0  2.0G   0% /dev/shm
/dev/sda5     9.2G  4.2G  4.6G  48% /home
/dev/sda7     100G   94G  1.1G  99% /var

Just needed to free up space. Fortunately, I was able to delete the mysql bin longs that were taking up almost 80GB of space.

user@computer$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1      19G  3.1G   15G  18% /
tmpfs                 2.0G     0  2.0G   0% /lib/init/rw
udev                   10M   64K   10M   1% /dev
tmpfs                 2.0G     0  2.0G   0% /dev/shm
/dev/sda5     9.2G  4.2G  4.6G  48% /home
/dev/sda7     100G   13G   83G  14% /var

Once that was done, I was able to restore the database.

Source:
https://forums.mysql.com/read.php?35,84004,224693#msg-224693

Advertisements
Categories: MySQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: