Hi,

Does anyone know how to modify table properties in mysql??? I just tried add a new entry to one of my tables and it gives the error:

ERROR 1036: Table 'blah' is read only

I am addiing it as root, i have corret privileges, table files have rwx for all users... i dont know what else to check??
Can anyone help me?
Thanks

Your mysql user (usually mysql) may be unable to write to the database, find where your mysql database files are and make sure that mysql user has rwx on the directory and rw on all the files and that the files are OWNED by mysql - chown them. Remove the other privileges e.g. chmod 660 and also make the directories 700 only mysql and root needs to go there.

There is also a problem noted on the mysql site:

"Charles Gregory: If you encounter "ERROR 1036: Table 'xxx' is read only", this may be due to a corrupt internal setting in MySQL. This can occur if, for example, you upload a new table from a Windows-based MySQL database directly to a Linux/Unix database. The solution is to use 'dumpmysql' to dump the databases, THEN be sure to DROP TABLE for the 'read only tables' or the internal config will not be properly reset! Deleting the table files is not sufficient. Once the tables are dropped, feed the dump file back to mysql, and it will create the tables anew, and they will be writable."

Thx for the reply rubyrat, but as I said I have the permission and the ownership for the files correct.
It is most probably an internal setting problem in mysql as your post said I will try the mysqldump, do u know what is meant by "feed the dump file back to mysql" though cause I dont wonna lose my table files after dropping the tables.

you can test by specifying a different database

mysql -u username -p MYNEWDATABASENAME < mysqldumpfile

Read all about it at http://www.sitepoint.com/print/678 they do a good guide.

As for the permissions sorry but you gave me the impression you were running mysql databases in directories set 777 (rwx rwx rwx) and files to 666 (rw- rw- rw-) mode.