data loads fail

[Rick Garland]

Hi all

Here are the specs I am working with

SOURCE
SuSE 10 32 bit, mysql 5.0.18
TARGET
CentOS 6.5 64 bit, mysql 5.1.73

Trying to get rid of the source system and want to migrate the data. The initial setup/configuration of the apache and new database with data was completed.

There is still some data on the SuSE system that was not in the database so I am trying to load it into the new database. When I do I get these messages and it will not commit and does a roll back.

DBD::mysql::st execute failed: Duplicate entry '174636084' for key 'PRIMARY' at ./loadMissingDailyDCETraffic.pl line 156.
commit ineffective with AutoCommit enabled at ./loadMissingDailyDCETraffic.pl line 165.
DBD::mysql::db do failed: Duplicate entry '174292913' for key 'PRIMARY' at ./loadMissingDailyDCETraffic.pl line 181.
Select Peer Data


Here are the sections of the script that is giving me problems

eval {
foreach $row ( @$results ) {
$stmt->execute( $row->[0], $row->[1], $row->[2], $row->[3],
"$row"->[4], "$row"->[5], "$row"->[6], "$row"->[7],
"$row"->[8], "$row"->[9], $row->[10], $row->[11],
$row->[12], $row->[13], $row->[14], $row->[15],
$row->[16], $row->[17], $row->[18], $row->[19],
$row->[20], $row->[21], $row->[22], $row->[23],
$row->[24], $row->[25], $row->[26], $row->[27] );
}

$dbh->commit();
};


$dbh->do( $copyToTargetTableSQL );

I can provide any additional info as needed/requested.

I am going from a 32bit to 64bit. I cannot see that matters for loading data but maybe I'm wrong?

Many thanks.
Rick