MySQL Forums
Forum List  »  Other Migration

mysqlimport deletes all existing rows
Posted by: Donald Campbell
Date: October 25, 2008 10:30AM

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?

Don C

Options: ReplyQuote

Written By
mysqlimport deletes all existing rows
October 25, 2008 10:30AM
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.