Thread: trying to import mysql database - crash

trying to import mysql database - crash

From

"Armbrust, Daniel C."

Date:

04 August 2003, 16:44:02

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

Re: trying to import mysql database - crash

From

"Dave Page"

Date:

04 August 2003, 16:48:13

-----Original Message-----
From: Armbrust, Daniel C. [mailto:Armbrust.Daniel@mayo.edu]
Sent: 04 August 2003 20:44
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] trying to import mysql database - crash

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.

Hi,

There is a bug in some versions of myODBC that causes this error. Please see http://archives.postgresql.org/pgadmin-support/2003-03/msg00068.php

Regards, Dave.