Page 1 of 1

Can you import 'exported' rows, into a MySQL DB?

Posted: Thu Feb 16, 2012 8:03 am
by simonmlewis
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?

Re: Can you import 'exported' rows, into a MySQL DB?

Posted: Thu Feb 16, 2012 8:30 am
by theserve
you can use phpmyadmin to export the data only so no table schemas. That way it wont try to create the table when you do the import.

Re: Can you import 'exported' rows, into a MySQL DB?

Posted: Thu Feb 16, 2012 8:37 am
by simonmlewis
How? I just did it, and try to deselect table options but it still has the "create table" in the script.