Thread: Database Migration Wizard
Hello,
I am attempting to migrate a mysql database to postgres, via the Database Migration Wizard.
I have setup the DSN on my XP workstation. I am able to test the datasource and connect successfully.
However, when following the steps required to connect to the datasource via the migration wizard (http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15), pgAdmin is crashing on me. The logs show the following:
2003-03-26 14:44:30 - SQL (template1): SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database ORDER BY datname
FYI - I am using the mysql ODBC driver found at http://www.mysql.com/downloads/download.php?file=Downloads%2FMyODBC3%2FMyODBC-3.51.06.exe&pick=mirror
Any insight would be greatly appreciated.
Thanks,
Sarah.
Sarah Atkinson
Global Applications Team Leader
Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha@lonelyplanet.com.au
______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner. |
Attachment
Hi Sarah,
The error you are seeing is almost certainly not caused by that SQL query as that is a standard tried and tested query executed by the main application to get statistics info. Can you please send me a complete Full Debug log of the crash occuring? You can change the log level under Tools -> Options.
Regards, Dave.
-----Original Message-----
From: Sarah Atkinson [mailto:Sarah.Atkinson@lonelyplanet.com.au]
Sent: 26 March 2003 03:52
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Database Migration WizardHello,I am attempting to migrate a mysql database to postgres, via the Database Migration Wizard.I have setup the DSN on my XP workstation. I am able to test the datasource and connect successfully.However, when following the steps required to connect to the datasource via the migration wizard (http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15), pgAdmin is crashing on me. The logs show the following:2003-03-26 14:44:30 - SQL (template1): SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database ORDER BY datnameFYI - I am using the mysql ODBC driver found at http://www.mysql.com/downloads/download.php?file=Downloads%2FMyODBC3%2FMyODBC-3.51.06.exe&pick=mirrorAny insight would be greatly appreciated.Thanks,Sarah.Sarah Atkinson
Global Applications Team Leader
Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha@lonelyplanet.com.au
______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner.
Attachment
Hi Dave,
Thanks for your email.
I down graded the ODBC driver and the plugin is now working.
FYI - If you have anyone else reporting this issue, MyODBC 2.50.19 looks to be the go!
Thanks again,
Sarah.
Sarah Atkinson
Global Applications Team Leader
Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha@lonelyplanet.com.au
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Friday, 28 March 2003 8:42 AM
To: Sarah Atkinson; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Database Migration Wizard
______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner. |
Attachment
Hi Sarah,
From what I can tell, the error lies with the MySQL ODBC driver. When connecting to it, it crashes where other drivers on my system work just fine. If there are other drivers for MySQL you could try one of those, or, contact the vendors for a fix. I have attached my VB test code in case it helps.
Sorry I cannot be more help.
Regards, Dave.
-----Original Message-----
From: Sarah Atkinson [mailto:Sarah.Atkinson@lonelyplanet.com.au]
Sent: 26 March 2003 23:20
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Database Migration WizardHi Dave,Thanks for your email.Attached are the various log files.Thanks for your help.Sarah.Sarah Atkinson
Global Applications Team Leader
Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha@lonelyplanet.com.au
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Wednesday, 26 March 2003 7:10 PM
To: Sarah Atkinson; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Database Migration WizardHi Sarah,The error you are seeing is almost certainly not caused by that SQL query as that is a standard tried and tested query executed by the main application to get statistics info. Can you please send me a complete Full Debug log of the crash occuring? You can change the log level under Tools -> Options.Regards, Dave.-----Original Message-----
From: Sarah Atkinson [mailto:Sarah.Atkinson@lonelyplanet.com.au]
Sent: 26 March 2003 03:52
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Database Migration WizardHello,I am attempting to migrate a mysql database to postgres, via the Database Migration Wizard.I have setup the DSN on my XP workstation. I am able to test the datasource and connect successfully.However, when following the steps required to connect to the datasource via the migration wizard (http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15), pgAdmin is crashing on me. The logs show the following:2003-03-26 14:44:30 - SQL (template1): SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database ORDER BY datnameFYI - I am using the mysql ODBC driver found at http://www.mysql.com/downloads/download.php?file=Downloads%2FMyODBC3%2FMyODBC-3.51.06.exe&pick=mirrorAny insight would be greatly appreciated.Thanks,Sarah.Sarah Atkinson
Global Applications Team Leader
Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha@lonelyplanet.com.au
______________________________________________________________________ This email, including attachments, is intended only for the addressee and may be confidential, privileged and subject to copyright. If you have received this email in error, please advise the sender and delete it. If you are not the intended recipient of this email, you must not use, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner.