trying to import mysql database - crash

From: "Armbrust, Daniel C(dot)" <Armbrust(dot)Daniel(at)mayo(dot)edu>
To: pgadmin-support(at)postgresql(dot)org
Subject: trying to import mysql database - crash
Date: 2003-08-04 19:43:31
Message-ID: 818623B5FD23D51193200002B32C07610D89790F@excsrv44.mayo.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm trying to copy a database from mySql to postgres - I'd like to compare their performance in a specific application.

I'm trying to use the database migration wizard in pgadmin 1.6.0. (Is there a better way to duplicate this database across?) Right after I click next after specifying the odbc database, pgadmin ungracefully crashes. And its not the new error catcher either, is the system level crash notification.

Here is all I can get out of a full debug log:

2003-08-04 14:36:29 - Entering pgAdmin II:frmMain.mnuPluginsPlg_Click(4)
2003-08-04 14:36:29 - Entering pgAdmin II:clsPlugins.Property Get Item("Database Migration Wizard")
2003-08-04 14:36:29 - Entering pgAdmin II:clsPlugins.Property Get Item("Database Migration Wizard")
2003-08-04 14:36:29 - Executing Plugin: Database Migration Wizard v1.6.0
2003-08-04 14:36:29 - Entering pgAdmin II:clsPlugins.Property Get Item("Database Migration Wizard")
2003-08-04 14:36:29 - Entering Database Migration Wizard:frmWizard.Initialise()
2003-08-04 14:36:30 - Entering Database Migration Wizard:frmWizard.optType_Click()
2003-08-04 14:36:44 - Entering Database Migration Wizard:frmWizard.cmdNext_Click()
2003-08-04 14:36:44 - Entering Database Migration Wizard:frmWizard.dbConnect()
2003-08-04 14:36:44 - Opening and Examining Source Database...
2003-08-04 14:36:44 - Opening DSN: mysql lvg
2003-08-04 14:36:44 - Entering Database Migration Wizard:frmWizard.GetQuoteChar("DSN=mysql lvg;UID=mirpub;PWD=mirpub")

Help ?

Thanks,

Dan

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-08-04 19:48:02 Re: trying to import mysql database - crash
Previous Message Nicolas, Leonardo Rizzo 2003-08-04 17:43:40 Error Message: ERROR: ALTER TABLE: column name "genera_factura" already exists in table "dat_comerciales"