What does df show?
-Original Message-
From: John Lepone [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2001 20:41
To: '[EMAIL PROTECTED]'
Subject: Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I don't think I'm out of room on the volu
Hi John,
Just listing the files and directories in your data directory won't
tell you (or anyone else here) if you're out of disk space.
Try:
$ df -k
to show your disk free space in K.
or, if you're in a directory, try
$ du -sk *
to show you a disk usage summary, in K, of the things in the dir
I don't think I'm out of room on the volume. Below is the directory
listing:
-rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001
-rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002
-rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003
27;\h' for help. Type '\c' to clear the
| buffer.
|
| mysql> CREATE DATABASE mynewdb;
| ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
| mysql>
|
|
| Likewise, if I try to add a table to an existing D
e '\c' to clear the
buffer.
mysql> CREATE DATABASE mynewdb;
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
mysql>
Likewise, if I try to add a table to an existing DB I get the following:
mysq
> mysql> CREATE DATABASE mynewdb;
> ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
> mysql>
[carsten@tsort carsten]$ perror 28
Error code 28: No space left on device
- Maybe clearing up some disk space would h
mysql> CREATE DATABASE mynewdb;
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
mysql>
Likewise, if I try to add a table to an existing DB I get the following:
mysql> use test;
Database changed