...
- Shut down License Statistics.
- 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 sure mysqld process/daemon is running.)
- Connect to the License Statistics database using the following command:
For Windows:mysql -uroot -hlocalhost -Dxformation_licstat --protocol=TCP
For Linux:./mysql -uroot -hlocalhost -Dxformation_licstat --socket=data/mysql.sock --protocol=TCP
- 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
- Restart License Statistics.
...