It's potentially dangerous to execute custom SQL statements on the database and can lead to data loss or corruption. Run this procedure only when requested to do so by X-Formation Support. |
We recommend that you make a backup of your database before performing any operations in order to avoid data loss or corruption. |
If you are using an embedded MySQL database, you can run a custom SQL script by following the procedure:
Windows
cd C:\Program Files\X-Formation\License Statistics\mysql |
Linux
cd /opt/x-formation/licstat/mysql |
Windows
mysql_start.bat |
Linux
sh mysql_start.sh |
Windows
mysql.exe -hlocalhost -uroot xformation_licstat < [download_file_directory]\script.sql |
Linux
mysql -hlocalhost -uroot xformation_licstat < [download_file_directory]/script.sql |
Windows
mysql_stop.bat |
Linux
sh mysql_stop.sh |
If you are using an external database (recommended), you need to perform the same steps as described above for an embedded database (except 5. and 7.), but with paths and credentials adjusted to your environment.