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
| Thread |
|---|
| • 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... | agd85 | 5 Jun |
| • 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'... | Reindl Harald | 5 Jun |
| • 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' ... | agd85 | 5 Jun |
| • 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'... | Reindl Harald | 5 Jun |
| • 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' ... | agd85 | 5 Jun |
| • 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'... | Reindl Harald | 5 Jun |
| • 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' ... | agd85 | 5 Jun |
| • 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'... | Reindl Harald | 5 Jun |
| • 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' ... | agd85 | 5 Jun |
| • 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'... | Reindl Harald | 6 Jun |
| • 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... | Johan De Meersman | 6 Jun |
| • 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' ... | agd85 | 6 Jun |
| • 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... | Johan De Meersman | 6 Jun |
| • 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' ... | agd85 | 6 Jun |
| • 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'... | Reindl Harald | 5 Jun |
| • 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' ... | agd85 | 5 Jun |
| • HowTo using mailing-lists | Reindl Harald | 5 Jun |
| • Re: HowTo using mailing-lists | agd85 | 5 Jun |
| • Re: HowTo using mailing-lists | Reindl Harald | 5 Jun |
| • Re: to the list AND the author | hsv | 6 Jun |
