List:General Discussion« Previous MessageNext Message »
From:agd85 Date:June 6 2011 5:03pm
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_instanc...
View as plain text  

On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman"
<vegivamp@stripped> wrote:
> > Excluding 'performance_schema' appears to eliminate the error. And it
> > seems does NOT cause a reliability-of-the-backup problem.
> 
> Hah, no, backing that up is utterly pointless.

that's a useful/final confirmation. thx.

> No, I do mean 3.3. Apparently the free downloadable version is quite a
> bit behind the commercial one. Maybe that's why I never noticed it
> backing up the performance schema, too :-)

i didn't catch that ZRM's commercial version was at 3.3!  thx.
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...agd855 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 Harald5 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' ...agd855 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 Harald5 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' ...agd855 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 Harald5 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' ...agd855 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 Harald5 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' ...agd855 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 Harald6 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 Meersman6 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' ...agd856 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 Meersman6 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' ...agd856 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 Harald5 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' ...agd855 Jun
              • HowTo using mailing-listsReindl Harald5 Jun
                • Re: HowTo using mailing-listsagd855 Jun
                  • Re: HowTo using mailing-listsReindl Harald5 Jun
            • Re: to the list AND the authorhsv6 Jun