User Manual

Home HomePre page For Mac User | Server Requirements Next page

Storing Data in MySQL


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.

Related links:

Installation


Home HomePre page For Mac User | Server Requirements Next page

About Us | Contact us | Company Blog | Partnership | Affiliate | Forum | Privacy policy | Terms of Use | SiteMap | Links

Call Sales Now! USA +1 315 636 6657, UK +972 59 9380061, HK +970 56 8169833

Share 123 Flash Chat:

Copyright © TopCMM Software Limited 2001-2016 All Rights Reserved.

Error: Table '123flashchat201311.ip_countries' doesn't exist