zmupdate.pl - 1.24.2 to 1.25.0 - mysqldump: Got error...

[skitz]

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:

Code: Select all

            $command .= " --skip-lock-tables";

Just before:

Code: Select all

            $command .= " --add-drop-table --databases ".ZM_DB_NAME." > ".$backup;

It's probably a hack but it worked.

[christophe_y2k]

Hello,
verify you have "create" access in you MySQL DataBase


# mysql> grant select,insert,update,delete,create on zm.* to 'zm_user'@localhost identified by 'zm_your_password';