Good day,
I'm having trouble restoring some db/data. Situation is as follows,
I have 2 structure wise identical databases. I need to export the data
from database A and import it to database B, which already contains
some of the data I exported from db A. So basically I need it to
ignore if data with same ID exists, but to append if the data is not there
yet. See it as an update of the db content.
How to go at this?
I tried
mysql -u username -p -f databasename < file.sql
this gave me errors. I tried the mysqlimport but in there it assumes
the file is 1 table...while it's a whole export.
Anyone??????
thank you
stepan
