Hi I have MySQL running on a RAQ4i. It has been running perfectly well for almost a year and has four separate databases on it.
Last week, whilst checking over the sites that make calls on these databases I noticed that only one had problems. Through searching the FAQs and online documentation I have narrowed down the problem to being something to do with the access permissions on the .frm files of the database tables. I am using PHP MyAdmin 2.2.1 to view and edit the tables and data. When I click the database to view the tables they are all displayed, but instead of showing the Records | Type | Size information all the tables show the phrase 'in use'. If I try to browse any of the tables I receive the error message: Error SQL-query : SELECT * FROM `about` LIMIT 0, 30 MySQL said: Can't find file: './gilmours/about.frm' (errno: 13) The file ./gilmours/about.frm does exist, by the way. I have backup copies of all the files (.frm, .MYI, .MYD) and by following the instructions in the online documentation have tried FLUSH TABLE, which runs without error, but doesn't give any change, I have tried all the repair options (REPAIR TABLE, myisamchk) and I have tried CHMODing the files, all without success, the same errors occur. I have also tried the 'very difficult repair' on this page : http://www.mysql.com/doc/R/e/Repair.html still leaving the same error. I cannot drop any tables or even the whole database itself, which would be a viable option as I have full backups of data and structure. I have changed the access restrictions to 666, 550, 777, and finally 660, which is what the tables in the other databases are, with no avail, I have restarted MySQL, numerous times, as well as rebooting the server. I have tried taking a working version of the same table from another database (they all are based on a similar structure) also with no success. The files as the moment stand as '-rw-rw---- mysql root about.frm' for example, is this correct? H E L P!! please... pretty please, with a cherry on top... Just an extra note, I am a newbie MySQL user, so please do not take anything for granted in your reply. This is my first post to this user group, but I have spent two days looking round the mailing list and FAQs to find the answer, but not really knowing what to search for has hampered my search. Any help will be gratefully and openly accepted. Thanking you in advance... Keiran Wynyard --------------------------------------------------------------------- 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
