libtransport.git Files · docs/guide/mysql.textile

Files @ e0f560a64814

Branch filter:

Location: libtransport.git/docs/guide/mysql.textile - annotation

e0f560a64814 881 B text/plain Show Source Show as Raw Download as Raw

Jan Kaluza

Added database.vip_statement, database.vip_only and database.vip_message variables

5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5
5e9d48751cd5

h2. 1. Editing the configuration file

To configure Spectrum 2 to use MySQL database, you have to edit following options in database section:

|_. Section |_. Key |_. Type |_. Change to value |_. Description |
| database| type | string | mysql | Database type - "none", "mysql", "sqlite3", "pqxx". |
| database| database | string | Name of the already create empty database | Database used to store data. |
| database| server | string | Database server | Database server. |
| database| user | string | MySQL user. | MySQL user. |
| database| password | string | MySQL Password. | MySQL Password. |
| database| prefix | string | | Prefix of tables in database. |

h2. 2. Creating the database

Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the MySQL database user you use to connect the SQL.