...
- 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.
- Connect to the License Statistics database using the following command:
For Windows:mysql -u root uroot -h localhost hlocalhost -tcp -Dxformation_licstat --protocol=TCP
For Linux:./mysql -u root uroot -h localhost hlocalhost -tcp -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.
...