List:General Discussion« Previous MessageNext Message »
From:Karam Chand Date:October 18 2004 3:52pm
Subject:Re: Transfering data from postgresql to MySQL
View as plain text  
Hello,

You can use SQLyog's ODBC Import Tool to import data
from PgSQL to MySQL using PgSQL's ODBC driver.

More information about SQLyog can be found at
http://www.webyog.com

Karam
--- Jochem van Dieten <jochemd@stripped> wrote:

> On Mon, 18 Oct 2004 18:08:24 +0800, > Patrick Hsieh wrote:
> > 
> > I am planing to transfer data from postgresql to
> mysql. Is there any
> > useful tools, scripts or  utilities to achieve
> this?
> 
> pg_dump
> 
> First dump the schema, edit that until you have
> something MySQL
> understands. Then dump the data using the -d option
> so you have full
> inserts instead of the usual COPY syntax and feed
> the file to the
> MySQL command line client.
> 
> Jochem
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 



		
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail 
Thread
Transfering data from postgresql to MySQLPatrick Hsieh(謝洪恩)18 Oct
  • Re: Transfering data from postgresql to MySQLJochem van Dieten18 Oct
    • Re: Transfering data from postgresql to MySQLKaram Chand18 Oct
    • Re: Transfering data from postgresql to MySQLPatrick Hsieh(謝洪恩)21 Oct
  • Re: Transfering data from postgresql to MySQLMartijn Tonies21 Oct