Versions Compared

Old Version 9

changes.mady.by.user Unknown User (mkos)

Saved on

compared with

New Version 10

changes.mady.by.user Unknown User (jlabuda)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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. (Make sure mysqld process/daemon is running.)

  4. 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

  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 Start License Statistics.

After performing these steps, the duplicate entry issues should be resolved.