errno 138
Hi all, We're trying to upgrade from 4.0.2 max to 4.0.16 Everything starts fine, but when querying the DB, something as simple as SELECT count(*) FROM myTable will return errno 138, but this works fine before the upgrade. Its probably something minor, but we're at a loss. Im not sure what other info to provide, ask and i'll tell thanks much, sean peters [EMAIL PROTECTED] filter buster: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
errno: 138
Hi I have just moved a copy of a database from and old MySQL server to a new one. But I am geting the folowing error. ---snip--- mysql select * from customers; ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) ---snip--- Can some one please tell me what this error is, or tell me where I can find a list of error to what the problem is. Thanks Simon Green Internet Systems Engineer -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - 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
errno: 138
Hi I have just moved a copy of a database from and old MySQL server to a new one. But I am geting the folowing error. ---snip--- mysql select * from customers; ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) ---snip--- Can some one please tell me what this error is, or tell me where I can find a list of error to what the problem is. Thanks Simon Green - 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: errno: 138
---snip--- mysql select * from customers; ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) ---snip--- http://www.mysql.com/doc/p/e/perror.html Regards Georg - 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: errno: 138
I think it's because it's the old structure, try this... BUT, back-up your database files first! Check that the owner of the database files are MySQL and that they have the correct permissions, then run the following statement : alter table customers type=MyISAM; K - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Mysql (E-mail)' [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 12:59 PM Subject: errno: 138 Hi I have just moved a copy of a database from and old MySQL server to a new one. But I am geting the folowing error. ---snip--- mysql select * from customers; ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) ---snip--- Can some one please tell me what this error is, or tell me where I can find a list of error to what the problem is. Thanks Simon Green - 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