MySQL Error : Table 'xxxxxx' is read only

[007]

I have a fairly large board that is growing fast. Lately I've noticed the following errors on a Windows 2003 server running IIS 6.0.

MySQL Error : Table 'word' is read only

or

MySQL Error : Table 'postindex' is read only

Among others.

I've done nothing (no mods or custom coding) that would effect these areas.

This is happening all the time now. Has anybody else had this happen before? How can I fix it?

[SEOvB]

Make sure the database user has full permissions to the database.

You can find your database user in your config.php file, and I've got no clue how to check the permissions on windows mysql :D

[kermit2]

You might want to try repairing the tables (eg via the mysql command line client), or it could be that another process has them locked. When you say 'all the time' do you literally mean all the time, or just very regularly?

[007]

By "all the time" I mean every few days, but when it happens it happens for 90% of posts, so I get about 200 emails about this (the auto emails) along with a few threads from members complaining.

If I repair and optimize tables the problem stops. It's only when I don't do that for a few days that this starts happening again.

[SEOvB]

When its occuring are you by chance backing up the databases?