From owner-freebsd-questions@FreeBSD.ORG Sat Feb 12 00:19:04 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E611616A4CE for ; Sat, 12 Feb 2005 00:19:04 +0000 (GMT) Received: from top.daemonsecurity.com (FW-182-254.go.retevision.es [62.174.254.182]) by mx1.FreeBSD.org (Postfix) with ESMTP id DBC8643D2D for ; Sat, 12 Feb 2005 00:19:03 +0000 (GMT) (envelope-from norgaard@locolomo.org) Received: from [192.168.0.32] (charm.daemonsecurity.com [192.168.0.32]) by top.daemonsecurity.com (Postfix) with ESMTP id B021DFD01F for ; Sat, 12 Feb 2005 01:19:01 +0100 (CET) Message-ID: <420D4B72.8060804@locolomo.org> Date: Sat, 12 Feb 2005 01:18:58 +0100 From: Erik Norgaard User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.5) Gecko/20050127 X-Accept-Language: en, en-us, da, it, es MIME-Version: 1.0 To: "freebsd-questions@freebsd.org" References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> <1108161011.23699.98.camel@lorna.circlesquared.com> In-Reply-To: <1108161011.23699.98.camel@lorna.circlesquared.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: SQL Questions -> migrating MySQL to PostgreSQL? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 12 Feb 2005 00:19:05 -0000 Peter Risdon wrote: > Postgresql is an excellent dbms and well worth a look. But if you're > starting out, I think mysql is the place to be. Ok, since the discussion is up, I have used MySQL for years, no problem serves my needs. Yet, I'd like to try out that PostgreSQL so many talks about. So, how do I migrate? I want to dump my mysql database - not big - and load it all into postgresql - of course it's perlable, but maybe there is an easier solution. Second, what do I need to change in my php scripts? Thanks, Erik -- Ph: +34.666334818 web: http://www.locolomo.org S/MIME Certificate: http://www.locolomo.org/crt/2004071206.crt Subject ID: A9:76:7A:ED:06:95:2B:8D:48:97:CE:F2:3F:42:C8:F2:22:DE:4C:B9 Fingerprint: 4A:E8:63:38:46:F6:9A:5D:B4:DC:29:41:3F:62:D3:0A:73:25:67:C2