mysqlhotcopy requires perl DBI and DBD-MySQL

V

vdvm

Verified User
Joined
Oct 5, 2005
Messages
39
Hi,

I want to use: mysqlhotcopy db_name /path/to/some/dir.
It seems that mysqlhotcopy requires perl DBI and DBD-MySQL.

Next steps:
yum install perl-DBI.i386
yum install perl-DBD-MySQL.i386

But when i try to install DBD i get an error.

What am i doing wrong?
Should i uninstall DBD or wasn't it installed at all because of the conflict?

Please help!
Thank you!

[root@server1 ~]# yum install perl-DBD-MySQL.i386
Setting up Install Process
Setting up Repos
base 100% |=========================| 1.1 kB 00:00
updates-released 100% |=========================| 951 B 00:00
Reading repository metadata in from local files
base : ################################################## 2622/2622
updates-re: ################################################## 1024/1024
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-MySQL.i386 0:2.9003-5 set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.10 for package: perl-DBD-MySQL
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:3.23.58-16.FC3.1 set to be updated
--> Running transaction check

Dependencies Resolved
Transaction Listing:
Install: perl-DBD-MySQL.i386 0:2.9003-5 - base

Performing the following to resolve dependencies:
Install: mysql.i386 0:3.23.58-16.FC3.1 - updates-released
Total download size: 3.3 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Check Error: file /usr/bin/comp_err from install of mysql-3.23.58-16.FC3.1 conflicts with file from package MySQL-devel-4.1.10a-0
file /usr/bin/mysql_config from install of mysql-3.23.58-16.FC3.1 conflicts with file from package MySQL-devel-4.1.10a-0
Click to expand...
 
Last edited:
I've also tried this:
http://www.directadmin.com/forum/showthread.php?threadid=764&highlight=dbd

Using DBI 1.40 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
gcc -c -I/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" dbdimp.c
gcc -c -I/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:101: error: too few arguments to function `mysql_shutdown'
make: *** [mysql.o] Error 1
gcc -c -I/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:101: error: too few arguments to function `mysql_shutdown'
make: *** [mysql.o] Error 1
Click to expand...

when i use mysqlhotcopy i get error:

Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Proxy, Sponge.
at /usr/bin/mysqlhotcopy line 178
Click to expand...
 
Thank you!

With Google i found this tutorial:
http://www.cs.wcupa.edu/~rkline/perl-mysql-lin.html

I still get an error when i use: mysqlhotcopy vbussel_db1 /backup

DBI connect(';host=localhost;mysql_read_default_group=mysqlhotcopy','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/mysqlhotcopy line 178
Click to expand...

What am i doing wrong now?

:(

I've tried also my ssh root password and the database password (--password=etc.)
 
Last edited:
You must log in or register to reply here.
Back
Top