Mysql read only database

How to make it writeable

[acidic]

I transferred all my databases from an old server to a new one by simply copying the .frm .MYD and .MYI files across. The problem is all these databases have now become read only. The users that access the databases have all privileges and all the database files are owned my MySQL. Any ideas on how to make the databases writable?

[Knowles]

What OS are you using, and depending on the answers have you checked permissions or properties on those files?

[acidic]

I'm running RHE. I created a new database with the same mysql user. I then set the owners and permissions of all files to exactly the same as the new database. I'm still getting the same error.

[Knowles]

RHE I assume is Red Hat Enterpise. If the permissions are set correctly then I would suggest trying to make another database on that server or even another table and see if you can write to it. If you still cant you may want to redo your instal of mysql to replace the files you replaced and do an export from the server to a file then an import to the new server to get the data over. Or check that the user you are trying write with has the access within mysql to write as well as read.