Hi!
>>>>> "Todd" == Todd Ratson <[EMAIL PROTECTED]> writes: Todd> Hi All, Todd> I have an OpenBSD box running mysql-3.23.47, php4.1.1 & Apache 1.3.22. Todd> I have been using php-nuke on it for some time now without incident Todd> until today... Todd> I have tried to create a new database in order to add another nuke based Todd> site to this server and I can't seem to import the sql file. This file Todd> is the same one I used to create the original (nuke 5.3.1) database. I Todd> have tried importing it in the shell and through phpMyAdmin-2.2.3 Todd> I always get an error stating that mysql cannot modify a .frm file. I Todd> downloaded a new copy of the sql file in case it was corrupt but I get Todd> the same error in a different .frm file. I then dumped a backup of the Todd> functioning db through phpMyAdmin and tried to import this sql file into Todd> a new db with the same results. Todd> An example of a table create that frequently fails and the error message Todd> is as follows: <cut> Todd> MySQL said: Todd> Can't create/write to file './test/nuke_authors.frm' Todd> I have even tried to manually copy the files in the db Todd> ie: cp -R /usr/local/mysql/var/db1/ /usr/local/var/db2/ Todd> When done this way, mysql crashes when I query the db: Todd> SQL-query : Todd> SHOW TABLE STATUS FROM `sample` Todd> MySQL said: Todd> Can't read dir of './sample/' (Errcode: 9) The above is very strange error: ------- (~) perror 9 Error code 9: Bad file descriptor ------- This is something that should never happen. Normally the problem in cases like this are that the mysqld process doesn't have the right to read/write to the database files, but it doesn't appear to be that in this case. Todd> The console is reporting the following error: Todd> 020122 10:50:35 Error in accept: Bad file descriptor I wonder if the error from accept could somehow influence the error from show table status or vice versa. <cut> If you could generate a trace file when this happens and send it to ftp://support.mysql.com/pub/mysql/secret we would try to solve this for you. The manual section at: http://www.mysql.com/doc/M/a/Making_trace_files.html tells you everything you need to know about how to make a MySQL trace file. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.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
