This problem appears to be similar to one I have when I create MySQL databases on my Windows machine and then transfer them at a later date to RedHat. MySQL looks for tables with the extensions MYD and MYI but they sometimes get converted to lowercase and thus MySQL complains (Linux is case-sesitive remember). Not sure what you can do to stop this happening but if you find a 'cure' could you let me know.
Cheers, Neil "Mikhail V.Soloviev" wrote: > Hello, > > sometimes my mysqld tells me that it cannot open the file table.MYD. > So script doensn't work, although the file exists in the > mysql/database/ folder. When I overwrite this file with backuped one, > problem disappears, and then appears again in several days. > What's the matter? > > p.s. Mysql 3.23.48 on RH 7.2, default config except wait_timeout=60 > > Best regards, > Mikhail Soloviev > > --------------------------------------------------------------------- > 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 > > *************************************************************** > This message was virus checked with: SAVI 3.53 Jan 2002 > last updated 30th January 2002 > *************************************************************** -- -------------------------------- Email: [EMAIL PROTECTED] [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
