zmupdate.pl - 1.24.2 to 1.25.0 - mysqldump: Got error...
Posted: Sat Sep 03, 2011 6:23 pm
FYI for anyone that runs into this...
When running zmupdate.pl, got the following error when trying to backup the database:
./zmupdate.pl -v 1.24.2
...
Creating backup to /tmp/zm/zm-1.24.2.dump. This may take several minutes.
mysqldump: Got error: 1044: Access denied for user 'zmuser'@'localhost' to database 'zm' when using LOCK TABLES
The host is Centos 5.5 x86_64 with mysql 5.0.77.
In /usr/local/bin/zmupdate.pl, added this line:
Just before:
It's probably a hack but it worked.
When running zmupdate.pl, got the following error when trying to backup the database:
./zmupdate.pl -v 1.24.2
...
Creating backup to /tmp/zm/zm-1.24.2.dump. This may take several minutes.
mysqldump: Got error: 1044: Access denied for user 'zmuser'@'localhost' to database 'zm' when using LOCK TABLES
The host is Centos 5.5 x86_64 with mysql 5.0.77.
In /usr/local/bin/zmupdate.pl, added this line:
Code: Select all
$command .= " --skip-lock-tables";
Code: Select all
$command .= " --add-drop-table --databases ".ZM_DB_NAME." > ".$backup;