If your chat uses MySQL database, you can follow the following:
1) Create database.
Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"
The [user],[password] here is MySQL account.
2) Import 123FlashChat table.
Enter the following commands in command prompt: <mysql installed directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installed directory>/server/etc/mysql.sql.
3) Modify fcserver.xml.
1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
2 Find this node: <database-mode>Derby</database-mode>, and change "Derby" to MySQL.
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 this file: <123flashchat installed directory>server/etc/Mysql.xml, and configure the relevant parameters according to the instructions, the section between <connection-pool>...</connection-pool> is database connection pool configuration and may be not need to be modified.
|