I've seen this similar issue in other postings, but haven't found a way to correct it. I haven't found any help in the manuals, either, so please someone explain what this is about.
MySQL v. 4.0.15 SuSE Linux 9.0 Database is very small: 6 tables, largest table around 5k. Ownership is mysql:root, permissions are 660 to all files. The database used to work, but then something must have broke, because now it is suddenly Read-Only (reports Read Only when I try to add a record using MySQLCC). If I copy the whole database (the whole directory) to a new directory, eg. cp -R dataset1 dataset2 where dataset1 is the "ReadOnly" database, the new dataset2 is ReadWrite. (ownership & permissions identical) If I then rename dataset1 to something else and rename dataset2 to dataset1, it becomes ReadOnly. Running myisamchk -c *.MYI shows everything is in order. I haven't found anything about this in the manuals, FAQ, mailing lists, so please explain what it's about, or point me in the right direction. /Marty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
