errno: 28

[thebobert]

Does anyone know why I can't create a new database. I have MySQL 3.23 -- Stable Release installed, everything else seems to work. I can delete databases but not create.

[thebobert]

ERROR 1006: Can't Create Database 'db name'. (errno: 28)

any help or comment appreciated.

[thebobert]

OKay good news, I finially found what the error means, no space left on the partition
What I need to know now if how to have it create the database on a diff partition.

[DR_LaRRY_PEpPeR]

all DBs are kept in the same place i think. if you want them on a diff partition you'll have to move them and change the datadir setting in MySQL.