X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 01BD911F6921 for ; Mon, 10 Apr 2006 06:00:31 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.047 X-Spam-Level: * X-Spam-Status: No, score=1.047 required=5 tests=[AWL=0.120, MSGID_FROM_MTA_ID=0.927] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id O0Jo6wYsvMN9 for ; Mon, 10 Apr 2006 06:00:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id B6DA211F6201 for ; Mon, 10 Apr 2006 06:00:26 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1437 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FSsFz-0006VK-4F; Mon, 10 Apr 2006 10:00:23 +0100 Reply-To: From: "Andy Shellam" To: "'Milen Dzhumerov'" Cc: Subject: Re: I have a question? Date: Mon, 10 Apr 2006 10:00:20 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: text/plain; charset="GB2312" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <44397E98.5080703@gmail.com> Thread-Index: AcZcHhLAwfAgzjHZSX+l8VRy0raKcQAXsjmw Message-Id: <20060410090026.B6DA211F6201@postgresql.org> X-Archive-Number: 200604/85 X-Sequence-Number: 21254 mySQL uses a weird CREATE TABLE syntax (with added options like table = engine type etc) that Postgres errors on - so some manual editing of the SQL = dump will be necessary. An export tool is probably the best way to go, = that'll read data from one ODBC driver and write it to another. = www.sqlmanager.net has some useful tools like that, and for a one-off job most of them come = as 30-day trials. Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql. org] On Behalf Of Milen Dzhumerov Sent: Sunday, 09 April, 2006 10:37 pm To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] I have a question? cruise0078 wrote: > Dear Firends: > Now I want to migrate all data from MySQL to PostGRESQL.There are > hands of tables in MySQL.I want to to know if there are some tools to > help me to do that.Also I want to know the key point to finish that > process and how much time it may take! Very Thanks! > cruise dong > > > > > > > =C4=E3 =D6=AA =B5=C0 2006 =C4=EA =D7=EE =BB=F0 =B1=AC =B5=C4 = =B5=E7=D7=D3 =D3=CA =CF=E4 =C2=F0 =A3=BF > =B6=E0 =B4=EF 1.1 =D2=DA =D6=D0 =B9=FA=C8=CB =D1=A1 =D4=F1 =CD=F8 = =D2=D7 2000 =D5=D7 =C3=E2 =B7=D1 =D3=CA =CF=E4 =A3=AC =C7=C0 =D7=A2 = =D4=D9 =B5=C3 > 280 =D5=D7 =B3=AC =B4=F3 =CD=F8 =C5=CC = You can use phpMyAdmin's functionality to export all the data to standard SQL files (.sql) and then use these to put the data back into PostgreSQL. Regards, gamehack ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster !DSPAM:14,44397f0d33691259350361!