MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mike Kruckenberg Date:November 17 2006 6:20pm
Subject:Re: mysqlhotcopy errors osx
View as plain text  
DBD::mysqlPP is the pure Perl driver for DBI. Is there a reason you are 
using that instead of DBD::mysql? I haven't done Perl/MySQL on OS X 
before but on other platforms (and from the error you're getting here) 
DBD::mysql is the typical driver for using DBI with MySQL. It also is 
the driver that mysqlhotcopy is built to use.

Mike

James Tu wrote:
> The first time I tried to run the mysqlhotcopy script, I got an error 
> that indicated that Perl couldn't find the DBI module.
> So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that 
> stepped me through making and installing
> MySQL DBD and the DBI modules(? don't know if I'm using the right 
> terminology here)
>
>
> However, during the 'make' step of the DBD module I got a warning:
> prompt$ sudo Perl Makefile.PL
> Checking if your kit is complete...
> Looks good
> Warning: prerequisite Net::MySQL 0.08 not found.
> Writing Makefile for DBD::mysqlPP
>
>
> So I decided to try to 'make install' anyway and I got...
> $ sudo make install
> Installing /Library/Perl/5.8.6/DBD/mysqlPP.pm
> Installing /usr/local/man/man3/DBD::mysqlPP.3pm
> Writing 
> /Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBD/mysqlPP/.packlist
> Appending installation info to 
> //System/Library/Perl/5.8.6/darwin-thread-multi-2level/perllocal.pod
>
> trying to run mysqlhotcopy again, I got...
> $ mysqlhotcopy --dryrun imaginon
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC 
> contains: /System/Library/Perl/5.8.6/darwin-thread-multi-2level 
> /System/Library/Perl/5.8.6 
> /Library/Perl/5.8.6/darwin-thread-multi-2level /Library/Perl/5.8.6 
> /Library/Perl /Network/Library/Perl/5.8.6/darwin-thread-multi-2level 
> /Network/Library/Perl/5.8.6 /Network/Library/Perl 
> /System/Library/Perl/Extras/5.8.6/darwin-thread-multi-2level 
> /System/Library/Perl/Extras/5.8.6 /Library/Perl/5.8.1 .) at (eval 7) 
> line 3.
> Perhaps the DBD::mysql perl module hasn't been fully installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysqlPP.
> at /usr/local/mysql/bin/mysqlhotcopy line 178
>
>
> line 178 of the script looks like:
>
> my $dbh = 
> DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
>                         $opt{user}, $opt{password},
>
> should I change the "dbi:mysql" part to "dbi:mysqlPP" ???
>
> or should I fix the earlier warning about Net:MySQL 0.08 not found 
> first.  Do I just install the Net package?
>
>
> ...OK
>
> I actually downloaded and installed Net:MySQL...
> sudo Perl Makefile.PL
> sudo make
> sudo make test
> sudo make install
> ...all went ok
>
> then I did the same steps for DBD
> ...all went ok and no warnings...
>
> But I'm still getting the same 'line 178' error.
>
>
>
> What am I not doing correctly?
> Thanks.
> -James
>
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
>

Thread
mysqlhotcopy errors osxJames Tu17 Nov
  • Re: mysqlhotcopy errors osxMike Kruckenberg17 Nov