MySQL - create table error 3 [HY000]

3.8k views Asked by At

Slowly but surely I am getting the hang of the command line methods rather than using the GUI, but I seem to be failing at creating tables in my database.

I'm getting the following error code:

ERROR 3 (HY000): Error writing file './10081552/people.frm' (Errcode: 28)

From some research I've performed, it normally means that there is no space, but I find that hard to believe as its on my uni's server and I have created zero data as of yet.

I'm using a simple test table like:

mysql> create table person (person_id char(3), dob date);

It must be something I have missed rather than lack of space

0

There are 0 answers