To backup a MySQL Database:
- Open a command prompt
- Change directory to the MySQL binary directory. For example: cd Agiliance_home\mysql\bin
- Type the following command and hit Enter: mysqldump -uroot -pxxxxx --database agiliance --add-drop-database --single-transaction --max_allowed_packet=32MB >Agldump07181.sql Note: replace xxxxx with correct password
- Store the backup file (dump file) on a separate server in a secure location.