Error: table is read-only
Posted: Fri Oct 04, 2002 6:13 am
Currently my company runs PHP and MySQL (3.23.52) on IIS (no we can't change to Apache much as I'd like to). At the beginning of this month we changed hosts and now we're having loads of problems with MySQL. Our previous server had Win NT4 and IIS 4 and the new one has Win2K and IIS 5.
The problems that we are now experiencing are incredibly frustrating and irritating. Firstly, tables can't be overwritten claim that they are in use even when the service has been stopped. Secondly the service crashed this morning and we had to reinstall MySQL (with exactly the same configuration settings as before) to get it going again. Then we could read from the database but not write to it and kept getting 'this table is read-only' errors when we tried. Eventually it decided that it could write as well as read from databases and we don't know why. Searching MySQL's docs and the web hasn't turned anything up and I just can't find anything about this error message. If someone else has experienced this before and/or knows what is causing it and how we can stop it happening you'd save me and my fellow developers a lot of headaches.
I have never had any problems with MySQL before and I'm fairly certain it's most likely something to do with IIS but any suggestions are welcome.
Mac
The problems that we are now experiencing are incredibly frustrating and irritating. Firstly, tables can't be overwritten claim that they are in use even when the service has been stopped. Secondly the service crashed this morning and we had to reinstall MySQL (with exactly the same configuration settings as before) to get it going again. Then we could read from the database but not write to it and kept getting 'this table is read-only' errors when we tried. Eventually it decided that it could write as well as read from databases and we don't know why. Searching MySQL's docs and the web hasn't turned anything up and I just can't find anything about this error message. If someone else has experienced this before and/or knows what is causing it and how we can stop it happening you'd save me and my fellow developers a lot of headaches.
I have never had any problems with MySQL before and I'm fairly certain it's most likely something to do with IIS but any suggestions are welcome.
Mac