Home > Archive > MySQL ODBC Connector > December 2005 > Re: [SOLUTION] some myisam tables turned read only (MySQL Max 4.1.12)









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [SOLUTION] some myisam tables turned read only (MySQL Max 4.1.12)
Johannes B. Ullrich

2005-12-30, 1:23 pm

-------------- enigA710BB0D517CB87B
B689E135
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


Well, I found the reason for these table becoming 'read only':

These tables where part of a merge table, which included some read only
tables (read only set in file system).

Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file system permissions.

very odd.. a bug?

to recover, you will have to:

- drop the merge table.
- create new tables
- insert the data from the old tables into the new tables
- drop the old tables
- rename the new tables to match the names of the old tables.
- change file system permissions on ALL the tables of the merge tables
- recreate the merge tables...




-------------- enigA710BB0D517CB87B
B689E135
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDtYNlKjDB6WiI
itoRA6/ AAJ4rdkNFTxRPPZ7NgiC
0tw9s5nVU0gCg2K9H
nntuKG4Js+to/xSWTvHuOFc=
=v4tl
-----END PGP SIGNATURE-----

-------------- enigA710BB0D517CB87B
B689E135--
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com