Automating Database Backup

Contents Previous Next

Upgrading KnowledgeTree > Backing up and Restoring > Automating Database Backup

This procedure automates the sql dump to run the database backup automatically, on all platforms.

Notes:

•	This procedure eliminates the need for user input of a password after you enter the -u and -p switches (in the command mysqldump -u dmsadmin -p dms > dump.sql)when performing a database backup.

Perform the following step:

1.	Add the following to the Pre-Backup Script: use --password=[xxx] in a batch file, which runs without user intervention.

Example:

mysqldump.exe -u dmsadmin -p dms --password=xxxx > sqldump.sql

Note: Provide a password to the -p/--password option