Adaptation for Migrating from MySQL to Kingbase

KDTS Tool Usage Guide

• Official KDTS tool usage guide: https://bbs.kingbase.com.cn/kingbase-doc/v8/development/develop-transfer/kdts-plus/index.html
• Best practice of migrating from MySQL to Kingbase: https://bbs.kingbase.com.cn/kingbase-doc/v8/development/develop-transfer/transplant-mysql/index.html

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. Restart the database.

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

Kingbase Database Null Value Settings

In Kingbase, the default value of ora_input_emptystr_isnull is true. If the inserted field information is empty, the field information is automatically converted to NULL and written to the database. You need to set ora_input_emptystr_isnull to false.

1. Go to the data directory.

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

2. Open the kingbase.conf file. Check whether the value of ora_input_emptystr_isnull is false. If it is not false, change it to false.
3. Restart the database.

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

Compatibility Between Kingbase and MySQL

Official compatibility guide: https://bbs.kingbase.com.cn/kingbase-doc/v8/development/develop-transfer/kes-vs-mysql/index.html