Error No : 1006
Error Type : Server Error
Error Code : SQLSTATE: HY000 (ER_CANT_CREATE_DB)
Error Message : Can't create database '%s' (errno: %d) Server Error
mysql> CREATE DATABASE myTable;
ERROR 1006 (HY000): Can't create database 'myTable' (errno: 28)
Reason: This error may occur when you do not have enough space on your server (HDD).
If you get his error, you need to check all filesystems where MySQL operates. It may be a single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. - MySQL docs
Solution:- Stop your MySQL server.
- Check filesystem space (command: df -h).
- Free up space by removing unwanted files.
- If you get this error on your Hosting database server (GoDaddy, Hostgator, etc) do check your space limit.
More Posts related to MySQL,
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Connection Failed: 1130 PHP MySQL Error
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- How to find AUTO_INCREMENT fileds value in mysql table
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
More Posts:
- How to know if someone has read your WhatsApp message - WhatsApp
- Android Studio NoClassDefFoundError: java.awt.Toolkit - Android-Studio
- WhatsApp launches WhatsApp Web to Access Messages over web browser - WhatsApp
- What is Android Toast.LENGTH_SHORT and Toast. LENGTH_LONG durations - Android
- Check Wifi Connection static Android Programming - Android
- Android Constant and Resource Type Mismatches Lint - Android
- How to Word wrap eclipse console logs width - Eclipse
- How to hide Navigation bar from Android Screen Activity - Android
- Share image and text Twitter using your Android Application Programatically - Twitter
- WhatsApp Web escanner - WhatsApp
- Programmatically check if Facebook is installed on Android device - Android
- Install Apache Tomcat ver 8 on Mac OS X Yosemite 10.10 - Mac-OS-X
- Disable Control Scroll Zoom-in and Zoom-out in Notepad++ - NotepadPlusPlus
- Can we move apps like WhatsApp, Facebook to external MicroSD card - WhatsApp
- Java: Check Internet connection on Android Device (Wifi or Mobile) - Android