mysqlimport deletes all existing rows
I am writing a series of scripts to take data from an existing Unify 2000 database and putting it into a MyQL v5.1.26 Databse.
I am loading the load using sqlimport and on the whole it is fine.
However I do have a couple of tables where I am going to have to run multiple imports where the imported data is in a different format and hence can not to run as a single job.
The issue I am finding is that the second mysqlimport deletes all existing rows from the table.
There is a --delete option to mysqlimport that does this, but it is not being used. Hence I would assume that it should not be deleting.
Any Ideas?
BR
Don C
Subject
Views
Written By
Posted
mysqlimport deletes all existing rows
5973
October 25, 2008 10:30AM
3243
October 27, 2008 02:30AM
3180
November 08, 2008 11:04PM
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.