Thread

  1. Migrating from MySQL

    Paul Fontenot <paul@code-slinger.com> — 2000-06-13T16:44:27Z

    Is this a simple matter of doing a mysqldump to a textfile and a copy into
    my new postgresql database?
    
    -Paul
    
    (P.S. If this comes across as html encoding please let me know.)
    
  2. Re: Migrating from MySQL

    Marc G. Fournier <scrappy@hub.org> — 2000-06-13T18:25:08Z

    On Tue, 13 Jun 2000, Paul Fontenot wrote:
    
    > Is this a simple matter of doing a mysqldump to a textfile and a copy into
    > my new postgresql database?
    
    nope, as MySQL has "features" that aren't compatible with other databases
    ... different ways of doing database structure, non-SQL compliant types,
    etc ... each database server tends to have their own quirks, some more
    then others ... you'll have to hand massage the mysqldump to fit
    PostgreSQL, but, having done it before, it is doable ...