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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
