Download the latest mysql connector J for you mysql server from their website. http://dev.mysql.com/downloads/connector/j/

I suggest placing the jar file this contains in the plugins/lib folder of CrushFTP and giving it the name "mysql.jar".

Then edit the prefs.XML file and set the following items:

<stats_db_url>jdbc:mysql://127.0.0.1:3306/crushftp_stats</stats_db_url>
<stats_db_driver>com.mysql.jdbc.Driver</stats_db_driver>
<stats_db_user>root</stats_db_user>
<stats_db_driver_file>plugins/lib/mysql.jar</stats_db_driver_file>

Make a new DB and call it "crushftp_stats". Below is the schema for it:

CREATE TABLE META_INFO (
  RID double NOT NULL,
  SESSION_RID double NOT NULL,
  TRANSFER_RID double NOT NULL,
  ITEM_KEY varchar(100) default NULL,
  ITEM_VALUE varchar(2000) default NULL,
  PRIMARY KEY  (RID)
);

CREATE TABLE SESSIONS (
  RID double NOT NULL,
  SESSION varchar(100) default NULL,
  SERVER_GROUP varchar(50) default NULL,
  USER_NAME varchar(100) default NULL,
  START_TIME datetime default NULL,
  END_TIME datetime default NULL,
  SUCCESS_LOGIN varchar(10) default NULL,
  IP varchar(50) default NULL,
  PRIMARY KEY  (RID)
);

CREATE TABLE TRANSFERS (
  RID double NOT NULL,
  SESSION_RID double NOT NULL,
  START_TIME datetime default NULL,
  DIRECTION varchar(8) default NULL,
  PATH varchar(255) default NULL,
  FILE_NAME varchar(2000) default NULL,
  URL varchar(2000) default NULL,
  SPEED int default NULL,
  TRANSFER_SIZE double default NULL,
  IGNORE_SIZE varchar(1) default NULL,
  PRIMARY KEY  (RID)
);