MySQL Forums
Forum List  »  Other Migration

data loads fail
Posted by: Rick Garland
Date: July 29, 2014 12:00PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
data loads fail
4988
July 29, 2014 12:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.