The information on this page refers to License Statistics v6.18 and newer, which introduced the CLI. If you are using an earlier version of License Statistics, please refer to the documentation for previous releases. |
| Warning |
|---|
Executing |
| Warning |
It's potentially dangerous to execute custom SQL statements on the database and can lead to result in data loss or corruption. Run this procedure only when requested to do so by X-Formation Support. |
| Info |
|---|
| We To avoid data loss or corruption, we recommend that you make a backup of always back up your database before before performing any operations in order to avoid data loss or corruption. |
...
| on the database. |
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 by using the following the procedure:
- Create a backup of your database.
- Stop License Statistics.
- Open a terminal/console in administration mode.
- Go to the mysql in the License Statistics installation directory.
For Windows:
Code Block language bash cd C:\Program Files\X-Formation\License Statistics\mysqlFor Linux:
Code Block language bash cd /opt/x-formation/licstat/mysql
Windows
Code Block language bash mysql_start.batLinux
Code Block language bash sh mysql_start.shxflicstat/bin
- Execute the SQL script delivered to you Execute SQL script delivered 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
Windows
Code Block language bash mysql_stop.batLinux
Code Block language bash sh mysql_stop.sh
- Start License Statistics.
Running custom SQL script on EXTERNAL database
...