If you are using a different user for the dump, than you could disallow priviliges to the general user, while dumping/truncating, and reset priviliges afterwards.
"FLUSH TABLES WITH READ LOCK" may be a better option. But haven't used it myself.
Last edited by pritaeas; Sep 7th, 2009 at 10:46 am.
Reputation Points: 550
Solved Threads: 728
Bite my shiny metal ass!
Offline 4,164 posts
since Jul 2006