http://qs321.pair.com?node_id=11113842


in reply to DBI lost connection

Are you using DBD::mysql or DBD::MariaDB? IIRC there was an issue with the former that was resolved in the latter.

Replies are listed 'Best First'.
Re^2: DBI lost connection
by luxs (Beadle) on Mar 05, 2020 at 11:36 UTC
    use DBI; my $dbh = DBI->connect( "DBI:mysql:database=".$config->{'mysql'}->{$db +}->{'d'}.";host=".$config->{'mysql'}->{$db}->{'h'}, $config->{'mysql'}->{$db}->{'u'}, $config->{'mysql'}->{$db}->{'p'}); $dbh->{'mysql_enable_utf8'} = 1; $dbh->do("SET NAMES 'utf8'"); $dbh->{mysql_auto_reconnect} = 1;