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 ag...@airpost.net: > 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
signature.asc
Description: OpenPGP digital signature
