If you need to store your data (such as user information or room information) in MySQL and you have had 123 Flash Chat v9.9 installed on your server, please follow the instructions below:

1 Create database

Start a command prompt in Windows or a Terminal in Linux, and run the following commands:

<mysql installation directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"

[user] and [password] is your MySQL account.

2 Import flashchat tables:

Please run the following commands: <mysql installation directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installation directory>/server/etc/mysql.sql

3 Edit fcserver.xml

3.1 Open this file: <123flashchat installation directory>/server/etc/fcserver.xml

3.2 Find this node: <database-mode>Derby</database-mode>, change "Derby" to "MySQL".

3.3 Find this node: <database-server port="10702" ip="localhost" enable="On"></database-server>

And change enable="On" to enable="Off".

4 Configure Mysql.xml

Open <123flashchat installation directory>server/etc/Mysql.xml, and configure the parameters according to the instruction, and this section: <connection-pool>...</connection-pool> is mainly used for database connection pool configuration, so it is unnecessary to modify.

5 Restart your chat server.