List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:June 5 2011 8:24pm
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_instance...
View as plain text  
have you checked you permissions-table if all privileges are active for root
and have you started "ymsql_upgrade" after all updates?

Am 05.06.2011 22:20, schrieb agd85@stripped:
> i use ZRM to do backups of my databases.
> 
> with v5.1.x, this works fine,
> 
>   mysql-zrm-scheduler --now --backup-set manual --backup-level 0
> 
> to execute a manual backup.
> 
> i recently upgraded from v5.1.x -> v5.5.12,
> 
>  mysqladmin -V
>   mysqladmin  Ver 8.42 Distrib 5.5.12, for Linux on i686
> 
> now, at exec of that backup cmd, i see an ERROR @ console,
> 
> 	...
> 	manual:backup:INFO: PHASE START: Creating raw backup
> 	manual:backup:INFO: Command used for raw backup is
> 	/usr/share/mysql-zrm/plugins/socket-copy.pl
> 	--mysqlhotcopy=/usr/bin --host="localhost" --port="3306"
> 	--socket="/var/cache/mysql/mysql.sock" --quiet  mysql 
> 	"/var/mysql-bkup/manual/20110605131003" >
> 	/var/cache/tmp/bZvaQFwQY2 2>&1
> 	manual:backup:INFO: raw-databases=mysql
> 	manual:backup:INFO: PHASE END: Creating raw backup
> 	manual:backup:INFO: PHASE START: Creating logical backup
> 	manual:backup:WARNING: The database(s) drupal6
> 	performance_schema will be backed up in logical mode since they
> 	contain tables that use a transactional engine.
> 	manual:backup:INFO: Command used for logical backup is
> 	"/usr/bin"/mysqldump --opt --extended-insert --create-options
> 	--default-character-set=utf8 --routines --host="localhost"
> 	--port="3306" --socket="/var/cache/mysql/mysql.sock" --databases
> 	drupal6 performance_schema  >
> 	"/var/mysql-bkup/manual/20110605131003/backup.sql"
> 	mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to
> 	user 'root'@'localhost' for table 'cond_instances' when using
> 	LOCK TABLES
> -->     manual:backup:ERROR: mysqldump did not succeed.
> 	 Command used is "/usr/bin"/mysqldump --opt --extended-insert
> 	 --create-options --default-character-set=utf8 --routines
> 	 --host="localhost" --port="3306"
> 	 --socket="/var/cache/mysql/mysql.sock" --databases drupal6
> 	 performance_schema  >
> 	 "/var/mysql-bkup/manual/20110605131003/backup.sql"manual:backup:INFO:
> 	 PHASE START: Cleanup
> 	manual:backup:INFO: backup-status=Backup failed
> 	...
> 
> 
> reading up on the error at,
> 
>  http://bugs.mysql.com/bug.php?id=33762
>  http://bugs.mysql.com/bug.php?id=49633
> 
> it looks to do with mysqldump itself.  i modified in /etc/my.cnf
> 
> 	...
> 	[mysqldump]
> 	quick
> 	quote-names
> 	max_allowed_packet = 8M
> +       skip-lock-tables
> 	...
> 
> but that doesn't seem to make any difference.
> 
> something's changed between 5.1.x & 5.5.x.
> 
> what do i need to modify to get past this error?
> 

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


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