Hidendra/LWC — Issue #219: Converting from SQLite to MYSQL
Author: sadleric
Created: 2012-01-20 08:34:13+00:00
State: open

Hello, Hidendra.

I must be missing someting, because I am unable to convert TrinityCraft's server from an SQLite db file to mySQL as per http://wiki.griefcraft.com/wiki/LWC/MySQL . With the following database node in config.yml,

database:
adapter: sql
path: plugins/LWC/lwc.db
host: localhost
database: lwc
username: root
password: trinity
prefix: lwc_

the following report is generated after a restart:

LWC Report
Version: [32m4.0.5 (b607)
Running time: [32m25 minutes 5 seconds
Players: [32m7/200
Item entities: [32m829/3094

==== Modules ====
LWC v4.0.5 (b607-git-e22604a9) -> 49 registered modules

==== Database ====
SQLite
Protections: 27,854
Queries: 23,874 | 15.86 / second

==== Cache ====
Refs: 10000/10000
Reads: 842 | 0.56 / second
Writes: 20,100 | 13.36 / second

The changes to config.yml did not incur a switch to mysql. I'm probably missing something :D

Thank you very much for the plugin! I appreciate your work.