Re: Error adding tables, databases, or records
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 hangs. 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 over. 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) mysql 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. Hi, $ perror 28 Error code 28: No space left on device Have you checked disc space ? Regards -- Joseph Bueno NetClub/Trader.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 adding tables, databases, or records
OK. I tracked the problem to being out of disk space in the var partition. The default source installation plaved the data in the /var/db directory. The var partition is not that large by default, and therefore I am now out of space. I would like to move the data to a /usr/local/mysql/data directory. What is the proper process to do this by? Is moving the data to that directory and changing the datadir location in safe_mysqld sufficient? Any help will be deeply appreciated. - 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 adding tables, databases, or records
perror 28 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 hangs. 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 over. 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) mysql 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - 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 adding tables, databases, or records
On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote: OK. I tracked the problem to being out of disk space in the var partition. The default source installation plaved the data in the /var/db directory. The var partition is not that large by default, and therefore I am now out of space. I would like to move the data to a /usr/local/mysql/data directory. What is the proper process to do this by? Is moving the data to that directory and changing the datadir location in safe_mysqld sufficient? That might work; dunno. Or you could: shell_ cd /var shell_ rmdir db shell_ ln -s /usr/local/mysql/data ./db ... I think. Then you wouldn't have to fiddle with mysql defaults at all. Of course, get your data out of /var/db before you rmdir /var/db. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - 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