List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 6 2011 4:54pm
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_instances...
View as plain text  
----- Original Message -----
> From: agd85@stripped
> 
> 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. Never noticed it doing that.

It's basically a virtual schema that contains realtime information about the database,
intended to replace a lot of "show tables" parsing and similar mayhem with simple select
statements.


> I believe that's an Amanda 3.3 release you're referring to. ZRM is
> still at 2.2,

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 :-)

They're not really that expensive, either, it might well be worth it to grab licenses and
support.



-- 
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...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