Thread:
Hi I have a postgresql in my red hat linux machine which will be our webserver. previously we had mysql in suse linux in another machine. so we are having a new webserver now with postgresql. I want to transfer my tables in mysql to postgresql so that I continue with my stuff in the new server. I tried to search for the transfer of tables from mysql to postgresql located on different machines, but could not figure out exactly how to start and proceed. could you please guide me through this process.... thank you prashanthi
On Tue, 3 Feb 2004, Prashanthi Muthyala wrote: > Hi > > I have a postgresql in my red hat linux machine which will be our webserver. > previously we had mysql in suse linux in another machine. so we are having > a new webserver now with postgresql. I want to transfer my tables in mysql > to postgresql so that I continue with my stuff in the new server. > > I tried to search for the transfer of tables from mysql to postgresql > located on different machines, but could not figure out exactly how to > start and proceed. > > could you please guide me through this process.... Download the postgresql source package, untar it, and look in the /contrib/mysql directory, or go to: http://ziet.zhitomir.ua/~fonin/code/ and download the latest version there.
On Tuesday 03 February 2004 17:46, Prashanthi Muthyala wrote: > > I tried to search for the transfer of tables from mysql to postgresql > located on different machines, but could not figure out exactly how to > start and proceed. There is a section on converting from MySQL at the url below. http://techdocs.postgresql.org/ Feel free to come back and ask some more if you have any problems. -- Richard Huxton Archonet Ltd
Look at
http://techdocs.postgresql.org/#convertfrom
There are several documents discussing converting from MySQL to PostgreSQL.
Jan
Prashanthi Muthyala wrote:
> Hi
>
> I have a postgresql in my red hat linux machine which will be our webserver.
> previously we had mysql in suse linux in another machine. so we are having
> a new webserver now with postgresql. I want to transfer my tables in mysql
> to postgresql so that I continue with my stuff in the new server.
>
> I tried to search for the transfer of tables from mysql to postgresql
> located on different machines, but could not figure out exactly how to
> start and proceed.
>
> could you please guide me through this process....
>
> thank you
> prashanthi
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #