The information on this page refers to License Statistics v4.8 or newer, which added the DenialUsers column to the database. If you are running a previous version of License Statistics, please refer to the documentation for versions prior to v4.8. |
---|
Duplicated license server entries after migrating to License Statistics v4.6.1 database
...
- 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 -h localhost -tcp -Dxformation_licstat
For Linux: ./mysql -u root -h localhost -tcp -Dxformation_licstat --socket=data/mysql.sock - 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.
...