RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
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: -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 -rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 -rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 -rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index -rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid -rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
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 directory. At 14:41 -0600 2001/12/17, John Lepone wrote: >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 >-rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 >-rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 >-rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index >-rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid >-rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* >drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ >srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= >drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ HTH /rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: -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 -rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 -rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 -rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index -rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid -rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
On Mon, 17 Dec 2001 14:20:11 -0600, John Lepone <[EMAIL PROTECTED]> wrote: | I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to | the DB as root. When I try to create a new DB, I get the following error: | | [jlepone@mandrake jlepone]$ su | Password: | [root@mandrake jlepone]# mysql -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 2 to server version: 3.23.46-log | | Type 'help;' or '\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 DB I get the following: | | mysql> use test; | Database changed | mysql> CREATE TABLE mynewtable (mycolumn int); | ERROR 3: Error writing file './test/mynewtable.frm' | (Errcode: 28) | mysql> | | can anyone help? Check your ownerships and permissions. All the directories and files in the mysql data dir should be owned by your mysql user and mysql group. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
Error code 28: No space left on device You're out of disk space on the drive where your databases are stored. Chris Schreiber -Original Message- From: John Lepone [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 3:20 PM To: '[EMAIL PROTECTED]' Subject: ERROR 1006: Can't create database 'mynewdb'. (errno: 28) I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to the DB as root. When I try to create a new DB, I get the following error: [jlepone@mandrake jlepone]$ su Password: [root@mandrake jlepone]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.46-log Type 'help;' or '\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 DB I get the following: mysql> use test; Database changed mysql> CREATE TABLE mynewtable (mycolumn int); ERROR 3: Error writing file './test/mynewtable.frm' (Errcode: 28) mysql> can anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
> 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. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to the DB as root. When I try to create a new DB, I get the following error: [jlepone@mandrake jlepone]$ su Password: [root@mandrake jlepone]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.46-log Type 'help;' or '\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 DB I get the following: mysql> use test; Database changed mysql> CREATE TABLE mynewtable (mycolumn int); ERROR 3: Error writing file './test/mynewtable.frm' (Errcode: 28) mysql> can anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php