Thread: mysql migration

mysql migration

From
Bryan Irvine
Date:
I have an older mysql implementation that is going to be upgraded soon.
Rather than upgrade it to another version of mysql I was thinking of
upgrading it to postgres.  Anyone done this?  What's the easiest way?

--Bryan


Re: mysql migration

From
joseph speigle
Date:
bryan,
there are scripts which will do the conversion of your dump file for you in the contrib/mysql directory of the source.

That will change the structure and syntax of the create statements/data types to postgresql ones.

joe

On Mon, Apr 19, 2004 at 03:50:30PM -0700, Bryan Irvine wrote:
> I have an older mysql implementation that is going to be upgraded soon.
> Rather than upgrade it to another version of mysql I was thinking of
> upgrading it to postgres.  Anyone done this?  What's the easiest way?
>
> --Bryan
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match