4
Troubleshooting

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:

• Defining the User Account
  
  
• Dumping MySQL Data
  
  
• Optimizing Command Line Options

  Note: For information on error messages, see the Error Messages topic in Appendix A of this guide.

Defining the User Account

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.

Dumping MySQL Data

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.

Command	Description
mysqldump	A tool that allows you to extract the schema and data in a MySQL database to a file.
mysql	Loads MySQL so you can carry out the command.
-u user name	The root MySQL user name. This user should have full DBA privileges.
-ppassword	The password of the root user of the MySQL database server
--opt	Optimizes table dumping speed and writes a dump file that is optimal for reloading speed. This option enables the -add-drop-table, --add-locks, --all, --extended-insert, --quick and -lock-tables options. For a list of definitions of the options enabled by --opt, refer to the Optimizing Options for MySQL section.
database_name	The name of the database containing the information you want to dump to an output text file.
<	Symbol used for re-directing the input in UNIX and NT.
file_name.sql	File name containing the MySQL database information.

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

Optimizing Command Line Options

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:

Command	Description
--add-drop-table	Adds a DROP TABLE IF EXISTS statement before each CREATE TABLE statement.
--all	Includes all of the MySQL specific create options.
--extended-insert	Writes multiple row INSERT statements.
--quick	Dumps directly to the standard output without buffering the query. If you suspend mysqldump while using this option, you may interfere with other clients because it could cause the server to wait.
--lock-tables	Locks all tables as read only.