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?
Can you import 'exported' rows, into a MySQL DB?
Moderator: General Moderators
-
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?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
Re: Can you import 'exported' rows, into a MySQL DB?
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?
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.
All the best from the United Kingdom.