I have a large embedded database file that i need to move to MySQL. I was able to look through all the jargon and find the data i needed (about 300,000 records). When I attempt to run INSERT for about 10 records some are skipped.
(Examples)
INSERT INTO OFMESSAGEARCHIVE VALUES(20116,'aheeva@chat.domain.com/spark','criss@chat.downetworks.com/spark',1260900807810,'yes i remember now');
INSERT INTO OFMESSAGEARCHIVE VALUES(20116,'aheeva@chat.domain.com/spark','criss@chat.downetworks.com/spark',1260900807810,'yes i remember now');
INSERT INTO OFMESSAGEARCHIVE VALUES(20116,'aheeva@chat.domain.com/spark','criss@chat.downetworks.com/spark',1260900807810,'yes i remember now');
INSERT INTO OFMESSAGEARCHIVE VALUES(20116,'aheeva@chat.domain.com/spark','criss@chat.downetworks.com/spark',1260900807810,'yes i remember now');
INSERT INTO OFMESSAGEARCHIVE VALUES(20116,'aheeva@chat.domain.com/spark','criss@chat.downetworks.com/spark',1260900807810,'yes i remember now');
Unfortunately, this is how the embedded database kept its records, so I figured it would be easiest to run them simultaneous. And of course some records are being skipped without error.
Please advise!
TIA