On Wed, 2003-06-11 at 01:55, Danny Cron wrote:
> I have three boxes. Mysqlhotcopy works on box1, but it generates a
> segmentation fault on box2 and box3. I want it to work on all boxes.
> I am prepared to upgrade them all to the level of box3 (but
> mysqlhotcopy doesn't work with that configuration). Does anyone know
> of a solution?
>
Hi,
I have had the same problem running mysqlhotcopy on the MySQL
installed with Woody. I think there is some problem with the
client library while it tries to parse the my.cnf file causing
a segmentation fault. I'm not sure if the problem is inside DBI
or the MySQL libs.
A quick solution is to remove the
"mysql_read_default_group=mysqlhotcopy" clause from the connection
string:
my $dbh =
DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
$opt{user}, $opt{password},
{
RaiseError => 1,
PrintError => 0,
AutoCommit => 1,
});
becomes:
my $dbh = DBI->connect("dbi:mysql:$dsn",
$opt{user}, $opt{password},
{
RaiseError => 1,
PrintError => 0,
AutoCommit => 1,
});
This loses the ability to use dedicated mysqlhotcopy sections
in your config file, but at least gets around the segfault.
regards,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
