Read Only Problem in MySQL

[evan18h]

I took my database from a windows version of mysql and copied it to a linux version and now all the databases I copied seem to be locked on read only, and give me this error:

#1036 - Table 'my_table' is read only

How can I fix so it is not read only?

[Sxooter]

It's likely a permissions issue at the file level. What user is mysql running under? Find out, and then go to the data directory and issue a command something like:

chown mysql.mysql *

You will likely need to do that for the directory itself so you can create new files.

[evan18h]

thanks that fixed another problem I had... but I am still having problems with read only. It happens when ever I attempt to insert anything into the database. And only happens to the databases I moved from windows.

[Sxooter]

After chowning the files and directory, are you getting the same error?

[evan18h]

yes... I used chown -R 777 /mysql-dir/
and I still get the read only error

[Sxooter]

do you mean

chown mysqld.mysqld -R /mysql/dir
chmod 770 /mysql/dir

?