Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

1030 Got error 28 from storage engine

Tags:

mysql

People also ask

How do I fix error 28 on storage engine?

To fix this you must increase the space of your filesystem or make room by deleting files. In other words your hard drive is full and MySQL needs more space. If you don't have access you must contact your host provider to report the issue.

Can t create table errno 28?

This error means that your mysql server does not have enough free space. You need to check the file system size and please remove unwanted software(s) or installers or files. What we suggest is please try to remove the files in /tmp first before you proceed to remove other files of software's.


Mysql error "28 from storage engine" - means "not enough disk space".

To show disc space use command below.

myServer# df -h

Results must be like this.

Filesystem    Size    Used   Avail Capacity  Mounted on
/dev/vdisk     13G     13G     46M   100%    /
devfs         1.0k    1.0k      0B   100%    /dev

To expand on this (even though it is an older question); It is not not about the MySQL space itself probably, but about space in general, assuming for tmp files or something like that. My mysql data dir was not full, the / (root) partition was


I had the same issue in AWS RDS. It was due to the Freeable Space (Hard Drive Storage Space) was Full. You need to increase your space, or remove some data.


My /tmp was %100. After removing all files and restarting mysql everything worked fine.


My /var/log/apache2 folder was 35g and some logs in /var/log totaled to be the other 5g of my 40g hard drive. I cleared out all the *.gz logs and after making sure the other logs werent going to do bad things if I messed with them, i just cleared them too.

echo "clear" > access.log

etc.