Read Data Problem from Derby to MySQL

When importing data from Derby to MySQL, open <your chat installation directory>/server/etc/Mysql.xml, and there is a nodemaximum-active-time, whose value limits the active duration of MySQL data connections.

As the Derby data is too large, the importing data duration may exceed the node’s value. Although there is no error message, the data in database still may not be fully read by the chat.

Solution:
You need to set a larger value and import data again.
The default value of maximum-active-time is 60000 (Millisecond), which is a minute.

To avoid this situation, we recommend you to set a larger value in advance when importing data.