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