5
MySQL Server Questions

This chapter contains frequently asked questions about using the Oracle Migration Workbench to migrate from a MySQL Server 3.22 or 3.23 database to an Oracle Server. It contains the following sections:

• Data Migration
  
  
• Migration Error Messages

Data Migration

This section contains a MySQL data migration question.

Are there any guidelines for how long it takes to convert high volumes of data from MySQL to an Oracle Server using the Migration Workbench?

No. Performance tests have not been carried out on the Migration Workbench data migration process. However, it is known that the setup affects performance. For example, if the Oracle Server and MySQL are not located on the same server, you must take the network bandwidth into account. Presently, data migration involves reading the data from the source MySQL database through a JDBC bridge and writing the data to the Oracle database through JDBC. It is a straightforward data pump. However, the Migration Workbench takes advantage of array inserts and `commit points' to improve performance. You can use the mysqldump scripts in conjunction with SQL*Loader to provide offline data loading for non-binary data.

Migration Error Messages

This section contains a MySQL error message question.

Why do I receive the "Communication link failure: bad handshake" error message when migrating from MySQL?

You may receive this error message during Step 1: Source Database Details of the Capture Wizard. To resolve this error message, verify the following conditions:

• The root user exists and has sufficient privileges on the MySQL server.
  
  
• The password you are using for the root user is correct.
  
  
• The password is exactly eight characters in length. In some versions of MySQL the password for the root user must be exactly eight characters to allow a connection through a third party product using JDBC or ODBC drivers. This is true even if a password that is not eight characters long allows you to connect through MySQL client programs.
  
  
• The server name, system (host) that you are connecting from has access rights to the MySQL user table.