From: Johan De Meersman
Date: June 6 2011 10:44am
Subject: Re: upgraded from 5.1->5.5.  now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES".  a bug or my config?
List-Archive: http://lists.mysql.com/mysql/225179
Message-Id: <865a059b-fc3a-4807-95b6-0fc9e7365ba2@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


I haven't bothered to look for the "bug", but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view.

I would rather take this up with the ZRM people - it should "just work". 3.3 came out last week, you may want to have a look at wether it's already been adressed there.

Harald's solution is, as usual, technically superior; but he keeps having trouble understanding people not wanting to change their entire setup because their solution isn't optimal :-)


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel