Bill, Wednesday, May 15, 2002, 11:42:00 PM, you wrote: BF> Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM BF> tables on which I am unable to do updates or inserts. I get error BF> message #1036 'Table is read only.' I am able to sign on to the database BF> through the root, set myself up as a superuser in the user table, and BF> have been able to set up test tables and make inserts etc. so it doesn't BF> look like a permissions issue. I thought that converting the tables to BF> myisam might help but of course I get the same error message. When I BF> copied one of the smaller tables into a new table I was able to update BF> it. (as a last resort I could do this on all the tables, but some are BF> large and it doesn't really address why the problem occurred) Any BF> suggestions would be very much appreciated. Thanks!
Check permissions on the table files. MySQL must be owner of these files. BF> - Bill Flanagan -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
