X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9465D1D516 for ; Tue, 3 Feb 2004 23:53:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07744-07 for ; Tue, 3 Feb 2004 19:53:29 -0400 (AST) Received: from smtp101.mail.sc5.yahoo.com (smtp101.mail.sc5.yahoo.com [216.136.174.139]) by svr1.postgresql.org (Postfix) with SMTP id 7394CD1D492 for ; Tue, 3 Feb 2004 19:53:26 -0400 (AST) Received: from unknown (HELO europa.janwieck.net) (janwieck@68.80.245.191 with login) by smtp101.mail.sc5.yahoo.com with SMTP; 3 Feb 2004 23:53:25 -0000 Received: from Yahoo.com (pcp01341166pcs.wilog301.pa.comcast.net [68.80.245.191]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id i13NrNr03855; Tue, 3 Feb 2004 18:53:23 -0500 Message-ID: <40202618.5000201@Yahoo.com> Date: Tue, 03 Feb 2004 17:52:08 -0500 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Prashanthi Muthyala Cc: pgsql-sql@postgresql.org Subject: Re: References: <3019.10.5.3.67.1075830381.squirrel@mail.spsu.edu> In-Reply-To: <3019.10.5.3.67.1075830381.squirrel@mail.spsu.edu> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/43 X-Sequence-Number: 16734 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 #