Page History

...

About running a custom SQL script

 In rare cases, X-Formation Support may ask you to run a custom SQL script to fix problems with the database.

You can run a custom SQL script on either an embedded database or an external database, as described below. All commands shown in the examples below use the default installation path. Adjust the commands to reflect your environment as necessary

...

.

Running a custom SQL script

...

You If you are using an embedded MySQL database, you can run a custom SQL script using the following procedure:

1. Create a backup of your database.
2. Stop License Statistics.
3. Open a terminal/console in administration mode. 
4. Go to mysql in the License Statistics installation directory. 

   • For Windows:

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

     
     

   • For Linux:

     Code Block
     language bash
     cd /usropt/xflicstat/mysql

   Start an embedded MySQL database using the mysql_start script.

   • For Windows:

     Code Block
     language bash
     mysql_start.bat

     For Linux:

     Code Block
     language bash
     sh mysql_start.shbin

     
     

5. Execute the SQL script delivered to you by X-Formation Support.

   • For Windows:

     Code Block
     language bash
     mysqlxflicstat-cli.exe storage apply -hlocalhost -uroot xformation_licstat <-confirm [download_file_directory]\script.sql

     
     

   • For Linux:

     Code Block
     language bash
     mysql -hlocalhost -uroot xformation_licstat <./xflicstat-cli storage apply --confirm [download_file_directory]/script.sql

   Stop the embedded MySQL database using the mysql_stop script.

   • For Windows:

     Code Block
     language bash
     mysql_stop.bat

     For Linux:

     Code Block
     language bash
     sh mysql_stop.sh

     
     

6. Start License Statistics. 

Running a custom SQL script on an external database

...