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]