Skip Headers

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
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

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

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.


Go to previous page Go to next page
Oracle
Copyright © 1998, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback