How to Fix MySQL Database error : Can’t create database ‘newdbname’ (errno: 28)

Share this Article :

Symptoms:
When i run the command to create new database on mysql, it was returned with below error message. How to fix this?

    mysql> CREATE DATABASE newdbname;
    ERROR 1006 (HY000): Can't create database 'newdbname' (errno: 28)
    

Findings and Solutions :
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. Or maybe you can ask the system administrator to increase the partition size.

    [[email protected] ~]# cd /tmp
    [[email protected] ~]# rm -rf *
    

Restart mysql server:

    [[email protected] ~]# service mysqld restart
    

Please re-run the below command:

    mysql> CREATE DATABASE newdbname;
    Query OK, 1 row affected (0.00 sec)
    


Leave a Reply