Am 05.06.2011 23:55, schrieb agd85@stripped:
> i still have no idea why this is necessary.
take it or not
it is a professional solution which works for
databses with 20 GB every day here with rsync
without interrupt/lock mysqld a second
and it is much faster
> there seems to be a but, problem, misconfiguration, etc.
> wouldn't it make some sense to try to FIX it, rather than setting up a
> completely different server?
it takes 5 minutes starting a replication salve on the same machine
with its own socket/port
> perhaps someone with an idea of the problem and its solution will be
> able to chime in.
wait until it is fixed or think about a better solution
which will work in the future
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 |
