write / read lock

[djedery]

Hey all - i have some mysql tables that i want to completely lock down while a script operates on them. Meaning, I want no other script to be able to read OR write to those tables.

It seems that if i read lock the tables, i then cannot update them even within the script that locked the tables. But if I write lock them, that does not prevent other scripts from reading them. Ugh.

Any way to accomplish what I'm after?

[superwormy]

Copy data to temporary tables, work on the temporary, copy back?

Not sure if that applies in your case...

[drawmack]

how about read locking except when you are reading, not perfect but pretty good.

[djedery]

actually - i misread the documentation. earlier on, it clearly states that write lock prevents all other threads from reading or writing to the tables.