Can you import 'exported' rows, into a MySQL DB?
Posted: Thu Feb 16, 2012 8:03 am
Hi
We are migrating to a new database. But in doing so, there is a period where there is newer content on the old system, than on the new one.
So once migrated over (during which time the old one will be used and rows inserted), I want to exported selected rows as SQL file, and then import them into the new DB.
How do I import those rows? I can't use Import. As that says the databse table already exists. But it must be simple... is it?
We are migrating to a new database. But in doing so, there is a period where there is newer content on the old system, than on the new one.
So once migrated over (during which time the old one will be used and rows inserted), I want to exported selected rows as SQL file, and then import them into the new DB.
How do I import those rows? I can't use Import. As that says the databse table already exists. But it must be simple... is it?