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 [at] m.gmane.org
Adarsh Sharma [ Di, 22 Februar 2011 10:21 ] [ ID #2055651 ]

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma <adarsh.sharma [at] orkash.com>:
> 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:
<http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_compatible>

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
<http://warp.es>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org
Jaime Crespo [ Di, 22 Februar 2011 10:25 ] [ ID #2055652 ]

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.

--
Thanks & Regards

Dhaval Jaiswal
Cell: +91 80953.978.43

________________________________

From: pgsql-general-owner [at] postgresql.org on behalf of Adarsh Sharma
Sent: Tue 2/22/2011 2:51 PM
To: pgsql-general [at] postgresql.org
Cc: mysql [at] 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 [at] 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=
..
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.
If you received this in error, please contact the sender and delete the mat=
erial from your computer.
Microland takes all reasonable steps to ensure that its electronic communic=
ations are free from viruses.
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.

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

<HTML dir=3Dltr><HEAD><TITLE>[GENERAL] Mysql to Postgresql</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dunicode">
<META content=3D"MSHTML 6.00.6000.17080" name=3DGENERATOR></HEAD>
<BODY>
<DIV id=3DidOWAReplyText28656 dir=3Dltr>
<DIV dir=3Dltr><FONT face=3D"Arial Narrow" color=3D#000000 size=3D3>Take a =
look at the Navicat for PostgreSQL.</FONT></DIV>
<DIV dir=3Dltr><FONT face=3D"Arial Narrow" color=3D#000000 size=3D3></FONT>=
 </DIV></DIV>
<DIV id=3DidSignature19288 dir=3Dltr>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>
<DIV class=3DMsoNormal><SPAN lang=3DEN-US style=3D"COLOR: #1f497d"><FONT co=
lor=3D#0000ff>--</FONT></SPAN></DIV>
<DIV class=3DMsoNormal><SPAN lang=3DEN-US style=3D"COLOR: #1f497d"><FONT co=
lor=3D#0000ff>Thanks & Regards</FONT></SPAN></DIV>
<DIV class=3DMsoNormal><SPAN lang=3DEN-US style=3D"COLOR: #1f497d"><FONT co=
lor=3D#0000ff></FONT></SPAN> </DIV>
<DIV class=3DMsoNormal><SPAN lang=3DEN-US style=3D"COLOR: #1f497d"><FONT co=
lor=3D#0000ff>Dhaval Jaiswal </FONT></SPAN></DIV>
<DIV class=3DMsoNormal><SPAN lang=3DEN-US style=3D"COLOR: #1f497d"><FONT co=
lor=3D#0000ff>Cell: +91 80953.978.43</FONT></SPAN></DIV>
<DIV class=3DMsoNormal></FONT><BR>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> pgsql-general-owner [at] postgresql.or=
g on behalf of Adarsh Sharma<BR><B>Sent:</B> Tue 2/22/2011 2:51 PM<BR><B>To=
:</B> pgsql-general [at] postgresql.org<BR><B>Cc:</B> mysql [at] lists.mysql.com<BR><=
B>Subject:</B> [GENERAL] Mysql to Postgresql<BR></FONT><BR></DIV></DIV></DI=
V>
<DIV>
<P><FONT size=3D2>Dear all,<BR><BR> Today I need to back up a mysql da=
tabase and restore in Postgresql<BR>database but I don't know how to achiev=
e this accurately.<BR><BR>Can anyone kindly describe me the way to do this.=
<BR><BR><BR>Thanks & best Regards,<BR><BR>Adarsh Sharma<BR><BR>--<BR>Se=
nt via pgsql-general mailing list (pgsql-general [at] postgresql.org)<BR>To make=
changes to your subscription:<BR><A href=3D"http://www.postgresql.org/mail=
pref/pgsql-general">http://www.postgresql.org/mailpref/pgsql -general</A><BR=
></FONT></P></DIV><pre>The information transmitted is intended only for the=
person or entity to which it is addressed and may contain confidential and=
/or privileged material.
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.
If you received this in error, please contact the sender and delete the mat=
erial from your computer.
Microland takes all reasonable steps to ensure that its electronic communic=
ations are free from viruses.
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.
</pre></BODY></HTML>
------_=_NextPart_001_01CBD29A.E70038BA--
Jaiswal Dhaval Sudhir [ Di, 22 Februar 2011 15:13 ] [ ID #2055657 ]

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 <adarsh.sharma [at] orkash.com>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 [at] 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

<div dir=3D"ltr">Please take a look at this article:<br><a href=3D"http://s=
ecurfox.wordpress.com/2010/12/12/converting-mysql-to-postgre sql/">http://se=
curfox.wordpress.com/2010/12/12/converting-mysql-to-postgres ql/</a><br><br>=
I think also, that there are a tool that can do this easly,<br>
Regards,<br><br><div class=3D"gmail_quote">On Tue, Feb 22, 2011 at 9:21 AM,=
Adarsh Sharma <span dir=3D"ltr"><<a href=3D"mailto:adarsh.sharma [at] orkash=
..com">adarsh.sharma [at] orkash.com</a>></span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin=
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Dear all,<br>
<br>
Today I need to back up a mysql database and restore in Postgresql database=
but I don't know how to achieve this accurately.<br>
<br>
Can anyone kindly describe me the way to do this.<br>
<br>
<br>
Thanks & best Regards,<br>
<br>
Adarsh Sharma<br><font color=3D"#888888">
<br>
-- <br>
Sent via pgsql-general mailing list (<a href=3D"mailto:pgsql-general [at] postgr=
esql.org" target=3D"_blank">pgsql-general [at] postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-general" target=3D"_bla=
nk">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>Ali MEZGANI<br>N=
etwork Engineering/Security <br><a href=3D"http://securfox.wordpress.com/">=
http://securfox.wordpress.com/</a><br>
</div>

--0016e644de46aa205d049ceb0c48--
mezgani ali [ Mi, 23 Februar 2011 04:54 ] [ ID #2055716 ]
Datenbanken » gmane.comp.db.mysql.general » Mysql to Postgresql

Vorheriges Thema: Mysql clustering
Nächstes Thema: ERROR 1005 (HY000): (errno: 150) details for show create table andinnodb status given