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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

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

Post 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?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
User avatar
theserve
Forum Newbie
Posts: 24
Joined: Wed Jan 18, 2012 6:35 am
Location: London

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

Post 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.
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

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

Post by simonmlewis »

How? I just did it, and try to deselect table options but it still has the "create table" in the script.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
Post Reply