Back-up Your MySQL Database

Before backing up your MySQL database, make sure you have stopped all RiskVision services.

To back up your MySQL database:

1. Log in as the Administrator.
2. Open the command window in the RiskVision database server host.

3. Enter the following line in the command window (ensure that the information is all in one line):

   %AGILIANCE_HOME%\MySql\bin\mysqldump -uroot -p<root password> --databases agiliance --routines --triggers --add-drop-database --single-transaction --max_allowed_packet=32MB > snap.sql

   The above command will back up your data to the  .sql file. Copy this file to the back-up directory.