Adaptation for Migrating from MySQL to Kingbase

KDTS Tool Usage Guide

For details, see KDTS Migration Tool User Guide and Best Practices for Migrating from MySQL to Kingbase.

Changing the Password of the Kingbase Database Administrator

After the Kingbase database is installed, the initial password of the system administrator account system is randomly generated. You can perform the following operations to change the initial password.

1. Go to the database installation directory.

   1	cd /opt/Kingbase/ES/V8/KESRealPro/V008R006C008B0020/Server/bin

2. Connect to the database.

   1	./ksql -U system -d KINGBASE

   Enter the password of the system user as prompted.

   1	Password for user system:

3. Change the password. Replace xxxxxx with the new password.

   1	alter user system with password 'xxxxxx';

Kingbase Database Compatibility Settings

Before data migration, adapt Kingbase parameters to MySQL. (Set the default value of the Kingbase database parameter mysql_interval_style to off.)

1. Go to the data directory.

   1	cd /opt/Kingbase/ES/V8/data

2. Open the kingbase.conf file and add the following content to the file:

   1	mysql_interval_style = on

3. Switch to user kingbase and restart the database.

   1	/opt/Kingbase/ES/V8/Server/bin/sys_ctl -D /opt/Kingbase/ES/V8/data restart

Compatibility Between Kingbase and MySQL

For details, see the official compatibility guide.