Mysql to Postgresql

Dear all,

Today I need to back up a mysql database and restore in Postgresql
database but I don't know how to achieve this accurately.

Can anyone kindly describe me the way to do this.


Thanks & best Regards,

Adarsh Sharma

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma :
> Dear all,
>
> Today I need to back up a mysql database and restore in Postgresql database
> but I don't know how to achieve this accurately.

Have a look at: "mysqldump --compatible=postgresql" command:


Anyway, most of the times you will need a more manual migration, with
human intervention (custom scripts) and migrating the data through
something like CSV (SELECT... INTO OUTFILE).


--
Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql to Postgresql

This is a multi-part message in MIME format.

------_=_NextPart_001_01CBD29A.E70038BA
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Take a look at the Navicat for PostgreSQL.
=20
--
Thanks & Regards
=20
Dhaval Jaiswal=20
Cell: +91 80953.978.43

________________________________

From: pgsql-general-owner@postgresql.org on behalf of Adarsh Sharma
Sent: Tue 2/22/2011 2:51 PM
To: pgsql-general@postgresql.org
Cc: mysql@lists.mysql.com
Subject: [GENERAL] Mysql to Postgresql



Dear all,

Today I need to back up a mysql database and restore in Postgresql
database but I don't know how to achieve this accurately.

Can anyone kindly describe me the way to do this.


Thanks & best Regards,

Adarsh Sharma

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


The information transmitted is intended only for the person or entity to wh=
ich it is addressed and may contain confidential and/or privileged material=
..=20
Any review, re-transmission, dissemination or other use of or taking of any=
action in reliance upon,this information by persons or entities other than=
the intended recipient is prohibited.=20
If you received this in error, please contact the sender and delete the mat=
erial from your computer.=20
Microland takes all reasonable steps to ensure that its electronic communic=
ations are free from viruses.=20
However, given Internet accessibility, the Company cannot accept liability =
for any virus introduced by this e-mail or any attachment and you are advis=
ed to use up-to-date virus checking software.=20

------_=_NextPart_001_01CBD29A.E70038BA
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The information transmitted is intended only for the=

 person or entity to which it is addressed and may contain confidential and=

/or privileged material.=20

Any review, re-transmission, dissemination or other use of or taking of any=

 action in reliance upon,this information by persons or entities other than=

 the intended recipient is prohibited.=20

If you received this in error, please contact the sender and delete the mat=

erial from your computer.=20

Microland takes all reasonable steps to ensure that its electronic communic=

ations are free from viruses.=20

However, given Internet accessibility, the Company cannot accept liability =

for any virus introduced by this e-mail or any attachment and you are advis=

ed to use up-to-date virus checking software.=20

Re: Mysql to Postgresql

--0016e644de46aa205d049ceb0c48
Content-Type: text/plain; charset=ISO-8859-1

Please take a look at this article:
http://securfox.wordpress.com/2010/12/12/converting-mysql-to -postgresql/

I think also, that there are a tool that can do this easly,
Regards,

On Tue, Feb 22, 2011 at 9:21 AM, Adarsh Sharma wrote:

> Dear all,
>
> Today I need to back up a mysql database and restore in Postgresql database
> but I don't know how to achieve this accurately.
>
> Can anyone kindly describe me the way to do this.
>
>
> Thanks & best Regards,
>
> Adarsh Sharma
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
Ali MEZGANI
Network Engineering/Security
http://securfox.wordpress.com/

--0016e644de46aa205d049ceb0c48
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable