Re: Newbie asks error 1036 table read only?
Make sure mysql owns the tables and their directorys, and has write privileges to them. I talking about UNIX permissions here, not mysql permissions. Bill Flanagan wrote: Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or inserts. I get error message #1036 'Table is read only.' I am able to sign on to the database through the root, set myself up as a superuser in the user table, and have been able to set up test tables and make inserts etc. so it doesn't look like a permissions issue. I thought that converting the tables to myisam might help but of course I get the same error message. When I copied one of the smaller tables into a new table I was able to update it. (as a last resort I could do this on all the tables, but some are large and it doesn't really address why the problem occurred) Any suggestions would be very much appreciated. Thanks! - Bill Flanagan - 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
Re: Newbie asks error 1036 table read only?
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
Newbie asks error 1036 table read only?
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or inserts. I get error message #1036 'Table is read only.' I am able to sign on to the database through the root, set myself up as a superuser in the user table, and have been able to set up test tables and make inserts etc. so it doesn't look like a permissions issue. I thought that converting the tables to myisam might help but of course I get the same error message. When I copied one of the smaller tables into a new table I was able to update it. (as a last resort I could do this on all the tables, but some are large and it doesn't really address why the problem occurred) Any suggestions would be very much appreciated. Thanks! - Bill Flanagan - 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