Oracle Migration Workbench Reference Guide for MySQL 3.22, 3.23 Migrations Release 9.2.0 for Microsoft Windows 98/2000, Microsoft Windows NT and Red Hat Linux 6.2 Part Number A97249-01 |
|
This chapter provides troubleshooting solutions and information on optimizing the command line options and avoiding issues connecting from the Migration Workbench to the MySQL server. It includes information on:
Note: For information on error messages, see the Error Messages topic in Appendix A of this guide. |
When you installed the MySQL server onto the system, the root user, a user account with full DBA privileges, was set up by default. You must log on to the MySQL server through the Migration Workbench using this root user. This is because the Migration Workbench attempts to connect to the MySQL server as the root user. Therefore, in Step 1: Source Database Details of the Capture Wizard the Source Login ID field is set to root and is grayed out. Therefore, you can not modify this field to login as another user.
If you are having difficulty migrating from MySQL to Oracle, you can contact the Migration Workbench support team. The Migration Workbench Development Team provides support and solutions to the migration problems. Choose Help -> Online Support to view information that explains how to report a problem. This also provides a list of the support options available.
You can provide the support team with a dump of the MySQL database. This helps in tracking the problem and providing a swift solution. By using the mysqldump
method to create a copy of the MySQL database you generate text files that are portable to other systems, even those with different hardware architecture. The Migration Workbench Development Team can regenerate the output into another database.
The table below provides an explanation of the code used to dump the MySQL data and to regenrate the database from the mysqldump
output text file.
To dump the MySQL data, use the following command:
% mysqldump -u user name -ppassword --opt database_name < file_name.sql
To regenerate the database from the mysqldump
output text file into a database, use the following command:
% mysql -u user name -ppassword database_name < file_name.sql
You automatically switch on options within the mysqldump
command line by using --opt
. For more information on dumping the MySQL data, refer to the Dumping MySQL Data section. The commands encompassed by the -opt commands are:
|
Copyright © 1998, 2002 Oracle Corporation. All Rights Reserved. |
|