If you need to store your data (such as user information or room information) in MySQL and you have had 123 Flash Chat v7.0 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 commends:

<mysql install 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 commends: <mysql install directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installed directory>/server/etc/mysql.sql

3 Edit fcserver.xml

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

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

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

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

4 Configure Mysql.xml

Open <123flashchat install 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.