Storing Chat data in MySQL DB (I)

[Roger]

Q: Your default DB in v7.x is not good. How could I Storing chat data into MySQL DB?

A: If you need to use MySQL to store your data (such as user information orroom information) in 123 Flash Chat v7.x, please following the instructions below:

PS: This Instruction just for the new installation of v7.x, if you have used for a while need transfer the data into MySQL, please according to How to Storing Chat data to MySQL DB (II)

1 Create database
Start a command prompt in Windows or a Terminal in Linux, and run the following commends:
mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"
[user] and [password] here is your MySQL account.

2 Import flashchat tables
Enter the folder “123flashchat/server/etc/", you will find "mysql.sql"
Then run the following commends:
mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat <mysql.sql

3 Edit fcserver.xml
Open this file: 123flashchat/server/etc/fcserver.xml
Find this node: change "Default" to "MySQL".
Find this node: <database-server port="9001" ip="localhost"enable="On"></database-server>
And change enable="On" to enable="Off".

PS: The code above is in v7.0, in other version, maybe a little different, please pay attention!

4 Configure Mysql.xml
Open 123flashchat/server/etc/Mysql.xml, and
configure the parameters according to the instruction, this section:
<database-user>mydbuser</database-user> should be the username of your
mysql as above [user].
<database-password>mydbpassword</database-password> should be the
password as above [password].

5 Restart your chat server

Note: In Step1, if you set the database name "123flashchat" to other name, such as "chat123", please open your "Mysql.xml", change the code "<database-name>flashchat</database-name>"
as "chat123".

Key word: MySQL, Storing Date