Migrating MySQL to EDB live guide via MTK

1.1 Migration Readiness

Is the Migration Toolkit (MTK) can use the migration function

1 Review the Migration source database testdb information. Total three Sheets

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center ">

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center ">

2 to enterprisedb official website downloads page Download MySQL driver, the driver is not related to the MySQL installation version number.

3 When the driver is downloaded, it is uploaded to a folder on the server via the FTP tool.

4 Decompression Drivetar -zxvf mysql-connector-java-5.0.8.tar.gz

5 cut into the Unzip folder. Then copy the MySQL drive jar package to/opt/postgresplus/edbmtk/lib

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center ">

6 copy one copy of MySQL drive jar package to $java_home/jre/lib/ext/

7 Change the CLASSPATH variable. and effective

Vim/etc/profile
Source/etc/profile

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center ">

8 creating the migrated EDB target database TestDB

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center ">

9 Edit/opt/postgresplus/edbmtk/etc/toolkit.properties File

SRC_DB_URL=jdbc:mysql://172.26.4.61:3306/testdbSRC_DB_USER=rootSRC_DB_PASSWORD=*************TARGET_DB_URL=jdbc:edb://localhost:5444/testdbTARGET_DB_USER=testdbTARGET_DB_PASSWORD=*************

10 Use the root user to cut into the MTK installation folder bin

1.2 Migration Implementation

1 start migration, from non-Oracle database migration mode, need to use -sourcedbtype db_type Specifies the source database type. Db_type value range: mysql/oracle/sqlserver/sybase , Db_type distinguishes between uppercase and lowercase, and its default value is Oracle
2 execute./runmtk.sh-sourcedbtype mysql testdb

3 because no migration log save path is specified, the migration log is saved by default under/root/.enterprisedb/migration-toolkit/logs

4 Assume that there are other personalized migration requirements. Please use the command to ./runMTK.sh -help view the use Help
5 Viewing log files

1.3 Migration Verification

1 after the migration is complete. View the migrated TestDB mode in PEM.

2 after the migration is complete, view the migrated TestDB mode and data in Navicat.

3 Validate this migration successfully with a sample.

Migrating MySQL to EDB live guide via MTK