Am 05.06.2011 23:49, schrieb agd85@stripped:
>
> 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?
because there is no lock on any production table?
have fun using mysqldump with really hughe databases :-)
a replication slave is synchron, you can stop the slave, copy
the whole datadir and after starting the slave it will
make all changes from the binary log
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
| 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 |
