Page History

...

To resolve this problem, compact the indexes of the affected table by running the SQL commands detailed in the following steps.below. (Make sure you have root privileges. Otherwise, you will not be able to perform the steps listed below.)

1. Shut down License Statistics.
   
   
2. 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.
   
   
3. Start the MySQL server by running mysql_start.bat for Windows or mysql_start.sh for Linux.
   
   
4. Connect to the License Statistics database using the following command:
   For Windows: mysql -u root -h localhost -tcp -Dxformation_licstat
   For Linux: ./mysql -u root -h localhost -tcp -Dxformation_licstat --socket=data/mysql.sock
   
   
5. Backup your data for the UsersCount table using the following SQL command:
   SELECT Date, Total, DailyUsers, Hosts, DenialUsers INTO OUTFILE 'userscount.dump' FROM UsersCount;
    
6. After successful backup, truncate the data and reset the index:
   TRUNCATE UsersCount;
ALTER TABLE UsersCount AUTO_INCREMENT = 1;
   
   
7. Restore the data:
   LOAD DATA INFILE 'userscount.dump' INTO TABLE UsersCount (Date, Total, DailyUsers, Hosts, DenialUsers);
   
   
8. Stop MySQL by running mysql_stop.bat/mysql_stop.sh
   
   
9. Restart License Statistics.
   

...