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

Forum for questions and support relating to the 1.25.x releases only.
Locked
skitz
Posts: 2
Joined: Fri Jun 18, 2010 8:08 am
Location: Santa Clara, CA

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

Post by 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
Posts: 102
Joined: Mon Oct 12, 2009 8:47 am
Location: EUROPE-FRANCE-MANDELIEU

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

Post by 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';
Locked