Comments - mysqlhotcopy

Currently we use mysql-zrm for backing up myisam tables. I am having problems with backups. Here is what i am seeing from the error log:

backup:INFO: Command used for raw backup is mysqlhotcopy --user="buuser" --password="*****" --port="3328" --socket="/data/tmp/mysql.db_instance" --quiet  db1 db2  "/var/lib/mysql-zrm/DB_INSTANCE/20130802114113" > /data/tmp/66gnOZYpTi 2>&1


DB_INSTANCE:backup:ERROR: Output of command: 'mysqlhotcopy' is 

{ 

install_driver(mysql) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
  at (eval 12) line 3

 Compilation failed in require at (eval 12) line 3.

 Perhaps a required shared library or dll isn't installed where expected
  at /usr/bin/mysqlhotcopy line 197
}


backup:ERROR: mysqlhotcopy did not succeed. Command used is mysqlhotcopy --user="buuser" --password="*****" --port="3328" --socket="/data/tmp/mysql.db_instance" --quiet  db1 db2 "/var/lib/mysql-zrm/DB_INSTANCE/20130802114113" > /data/tmp/66gnOZYpTi 2>&1 Return value is 65280

line 197 in mysqlhotcopy:

(mysqlhotcopy version : 1.23)

 197 my $dbh = DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",

 198                         $opt{user}, $opt{password},

 199 {

 200     RaiseError => 1,

 201     PrintError => 0,

 202     AutoCommit => 1,

 203 });

Please help.

Thanks

I'm positive this has to do with the mariadb's socket

( i am currently running mariadb version 5.5)

Some questions:

1. I'm not that familiar with the inner workings of mysql-zrm. Does it have its own version of mysqlhotcopy, or is it using the version from MariaDB? Since the full path listed in the error message is /usr/bin/mysqlhotcopy my guess is that you're using the version from MariaDB, but I wanted to make sure.

2. Are you able to run mysqlhotcopy by itself? for example:

   sudo mysqlhotcopy --user="buuser" --password="*****" db1 ./
   

3. The error looks like mysqlhotcopy can't find the file /usr/local/lib64/perl5/auto/DBD/mysql/mysql.so Does that file exist?

4. Why are you positive it has to do with MariaDB's socket?

Thanks.

1) No MYSQL-ZRM uses the default mysqlhotcopy ( which currently is at 1.23 i believe)

2) mysqlhotcopy does not run by itself but when i reinstall mysql5.6.3 for instance both mysql-zrm and mysqlhotcopy run without any errors.

This is the reason why i think there is some incompatibility in the maria's client socket.

Are you running MariaDB 5.5.32? Also, what distribution/version are you running it on?

I'm able to run mysqlhotcopy just fine on my local desktop, but I'd like to try and duplicate your issue if I can so we can figure out a solution.

Thanks.