...
- Shut down License Statistics (Make make sure xflicstat process/daemon is not running).)
- From a command line, navigate to the License Statistics installation directory, and then to mysql_x86 for 32-bit databases or mysql_x64 for 64-bit databases.
- Start the MySQL server by running mysql_start.bat for Windows or mysql_start.sh for Linux . (Make make sure mysqld process/daemon is running).)
- Connect to the License Statistics database server using the following command:
For Windows:mysql.exe -uroot -hlocalhost --protocol=TCP
For Linux:./mysql -uroot -hlocalhost --socket=data/mysql.sock --protocol=TCP - Check the License Statistics database location corresponds with information from below query output:
> SELECT @@datadir; - Pick the database name then (you can check it in xflicstat.cfg file, default name is xformation_licstat):
> USE xformation_licstat - Backup your data for the UsersCount table using the following SQL command:
> SELECT Date, Total, DailyUsers, Hosts, DenialUsers INTO OUTFILE 'userscount.dump' FROM UsersCount;
- After successful backup, truncate the data and reset the index:
> TRUNCATE UsersCount;
> ALTER TABLE UsersCount AUTO_INCREMENT = 1; - Restore the data:
> LOAD DATA INFILE 'userscount.dump' INTO TABLE UsersCount (Date, Total, DailyUsers, Hosts, DenialUsers); - Stop MySQL by running
mysql_stop.bat/mysql_stop.sh - Start License Statistics.
...