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 volume. Below is the directory
listing
;
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
mysql CREATE TABLE mynewtable (mycolumn int
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 help???
/ Carsten
--
Carsten H
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
mysql CREATE TABLE
' 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:
|
| mysql use test
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
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