Page History

...

Initial statements 

1. In rare cases, X-Formation Support can ask to run a custom SQL script to fix some problems in the database.
2. All example commands shown below are using the default installation path. Adjust the commands to your environment if necessary.
3. More details about using mysql_* scripts delivered with License Statistics are available on the Backing up and restoring an embedded database page.

Running custom SQL script on EMBEDDED database

...

1. Create a backup of your database.
2. Stop License Statistics.
3. Open terminal/console in administration mode. 
4. Go to the mysql directory in the License Statistics installation directory. All example commands described below should be executed in this directory. 

   • Windows

     Code Block
     language bash
     cd C:\Program Files\X-Formation\License Statistics\mysql

     
     

   • Linux

     Code Block
     language bash
     cd /opt/x-formation/licstat/mysql

     
     

5. Start embedded MySQL database using the mysql_start script

   • Windows

     Code Block
     language bash
     mysql_start.bat

     
     

   • Linux

     Code Block
     language bash
     sh mysql_start.sh

     
     

6. Execute SQL script delivered by X-Formation Support

   • Windows

     Code Block
     language bash
     mysql.exe -hlocalhost -uroot xformation_licstat < [download_file_directory]\script.sql

     
     

   • Linux

     Code Block
     language bash
     mysql -hlocalhost -uroot xformation_licstat < [download_file_directory]/script.sql

     
     

7. Stop embedded MySQL database using the mysql_stop script

   • Windows

     Code Block
     language bash
     mysql_stop.bat

     
     

   • Linux

     Code Block
     language bash
     sh mysql_stop.sh

     
     

8. Start License Statistics. 

Running custom SQL script on

...

EXTERNAL database

If you are using an external database (recommended), you need to perform the same steps as described above for an embedded database, but with paths and credentials adjusted to your environment.