On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
<h.reindl@stripped> wrote:
> i would use a replication slave and stop him for consistent backups
> because dumb locks are not really a good solution independent
> if this works "normally"
unfortunately, i have no idea what that means.
something's apparently broken with mysqldump -- enough so that lots of
people are seeing and reporting this same error after the 5.1 -> 5.5
upgrade.
why would setting up a replication slave be necessary or a good solution
to the problem?
| 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 |
