From owner-freebsd-questions@FreeBSD.ORG Sat Feb 12 00:28:40 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 CF7C916A4CE for ; Sat, 12 Feb 2005 00:28:40 +0000 (GMT) Received: from smtp100.rog.mail.re2.yahoo.com (smtp100.rog.mail.re2.yahoo.com [206.190.36.78]) by mx1.FreeBSD.org (Postfix) with SMTP id 04EB143D3F for ; Sat, 12 Feb 2005 00:28:40 +0000 (GMT) (envelope-from Mike.Jeays@rogers.com) Received: from unknown (HELO ?192.168.2.100?) (mjeays2551@24.114.152.139 with plain) by smtp100.rog.mail.re2.yahoo.com with SMTP; 12 Feb 2005 00:28:39 -0000 From: Mike Jeays To: Erik Norgaard In-Reply-To: <420D4B72.8060804@locolomo.org> References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> <1108161011.23699.98.camel@lorna.circlesquared.com> <420D4B72.8060804@locolomo.org> Content-Type: text/plain Message-Id: <1108168118.700.37.camel@chaucer.jeays.ca> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Fri, 11 Feb 2005 19:28:38 -0500 Content-Transfer-Encoding: 7bit cc: "freebsd-questions@freebsd.org" 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:28:40 -0000 On Fri, 2005-02-11 at 19:18, Erik Norgaard wrote: > 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 There is an article on converting a database from MySQL to PostgreSQL on the FreeBSD Diary. I have done it myself with a very small database - I just did a mysqldump, and made a few edits by hand to remove MySQLisms, and then loaded it with psql. No major gotchas at all. I prefer PostgreSQL - it seems a more complete and professional product to me - not to speak ill of MySQL, which is enormously successful. A pity that PgAccess still needs lots of work, as a competitor to Access.