Error code 28: No space left on device
Benjamin Krajmalnik wrote:
> I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
> I am running 3 databases off of a single mySQL server.
> In one particular database I am unable to insert records - the process just
> My intuition would tell me that maybe something is corrupted in the index.
> Since I have no problem whatsoever selecting records from the database, I
> thought I would create a new table with the same schema and copy the records
> HOWEVER, although I am logged in as root and root has full priviledges in
> the user table, I am unable to either create new databases or add new
> tables. This is getting extremely frustrating.
> Below is a sample of the results:
> mysql> use aplcore
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> Database changed
> mysql> create table test (ID int);
> ERROR 3: Error writing file './aplcore/test.frm' (Errcode: 28)
> I have set the access rights for the aplcore directory under mySQL to 776 to
> make sure it was not an access issue.
> Any help will be deeply appreciated - this needs to be resolved ASAP.
> Also, I am logged in as the superuser account.
> 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 <mysql-thread84057@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Gerald L. Clark
|• Error adding tables, databases, or records||Benjamin Krajmalnik||30 Aug|
| • Re: Error adding tables, databases, or records||joseph.bueno||30 Aug|
| • RE: Error adding tables, databases, or records||Benjamin Krajmalnik||30 Aug|
| • Re: Error adding tables, databases, or records||s. keeling||30 Aug|
| • Re: Error adding tables, databases, or records||Gerald Clark||30 Aug|