Re: SQL Questions -> migrating MySQL to PostgreSQL?

From: Erik Norgaard (norgaard_at_locolomo.org)
Date: 02/12/05

  • Next message: Mike Jeays: "Re: SQL Questions -> migrating MySQL to PostgreSQL?" 
    Date: Sat, 12 Feb 2005 01:18:58 +0100
To: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>

    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
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
  • Next message: Mike Jeays: "Re: SQL Questions -> migrating MySQL to PostgreSQL?"

    Relevant Pages

    • Re: Access als Frontend für verschiedene DBMS testen
      ... >> Diese DBMS habe ich mir angesehen: JET, MSSQL, PostgreSQL 8.0, MySQL ... Datentypen im FE erkannt? ... Warum ich PostgreSQL vor MySQL stellte: ...
      (microsoft.public.de.access)
    • Re: Effect of MySQL being acquired by Sun Micro
      ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... I didn't know SQL support was added that late. ...
      (comp.lang.php)
    • Re: Python, xml, databases, ...
      ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
      (comp.lang.python)
    • Re: Effect of MySQL being acquired by Sun Micro
      ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... By the time Postgres became PostgreSQL, mSQL already had a strong foothold ...
      (comp.lang.php)
    • Re: pro- foreign key propaganda?
      ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
      (comp.databases.theory)