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 <mysql-thread109161@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
