Mailinglist Archive: opensuse (3217 mails)

[Smartyone <marty.one@xxxxxxxxxx>]

Sorry for this OT subject, but I have asked this before on the mysql-list to 
no avail. Thought I give it a try on this forum, IF someone happens to 
recognize the problem.

[MySQL v. 4.0.15, SuSE 9.0]

Database: Dataset1, very small, all files together only some 75k.

Everything worked for weeks, then suddenly this database became ReadOnly.
Here are some facts:

- All files in the directory Dataset1 are: [user: mysql | group: root]; 
permissions are 660.

- MySQL supplies an utility - myisamchk - to check table integrity. It reports 
no problems.

- Since the tables are MyISAM, making a copy of the database is as simple as 
copying the whole directory under a different name (e.g. Dataset2). If I do 
that (AND clone the ownership/permissions), Dataset2 is Read/Write.

- If I rename Dataset1 to DatasetRO, and the rename the Read/Writeable 
Dataset2 to Dataset1, the "new" Dataset1 is  - ReadOnly.

- All other databases are Read/Write. (AND user/group are mysql/root, AND 
permissions are 660).

I haven't found how/where to change database permissions within mysql, I have 
no idea where to go now.

Any clues?

rgds,
/Marty