On 8/4/06, Gilbert T. Gutierrez, Jr. <
plug@phxinternet.net> wrote:
>
> I am not that familiar with PostGreSQL and made a mistake in selecting it
> for this application. I can, I am sure move the data. The issue is the
> time it will take me. Someone that is familiar may be able to do this
> quicker than me. The app also has a way to export data and then re-import
> it that I may end up using, I am just not comfortable that it will export
> all data.
>
You can move data either way using the dump commands.
For instance:
1) pg_dump -U postgres -D mydb > mydb.sql
(-D makes extended inserts)
2) mysql -u root newdb < mydb.sql
Please watch closely for errors. It is possible you'll need to edit the
table definitions (data types) when converting from 1 DB to another. If you
are using foreign keys you'll need to be careful to select a backend data
type in MySQL that supports this.
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)