I've been running a HL Deathmatch server for a while now, however it's on Windows 2003 32bit, so I've built a Windows 2012R2 64bit server (have a OS license) and I've got the server up and running again. However the HLstats I've not managed to get setup at all, I made no notes years ago either.
I've installed MySQL and have tried to import the install.sql
I had to create the database first via the MySQL Shell:
mysql> create database hlstatsx;
Query OK, 1 row affected (0.01 sec)
Then via command line I tried to import the script to build the tables, but get an error:
C:\Users\dummyaccount>mysql -u root -p hlstatsx < c:\hlstatsx\sql\install.sql
Enter password: *********
ERROR 1265 (01000) at line 65: Data truncated for column 'for_PlayerPlayerAction
s' at row 1
Any ideas what I'm doing wrong?