Routine Periodic Backups

You can manually backup the AppDynamics for Databases database using the standard mysqldump.exe utility, which is included in the AppDynamics for Databases installation directory.

The mysqldump.exe utility is documented here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

The mysqldump.exe utility is located in the following directory for AppDynamics for Databases:

<Appd4DB install directory>/mysql/bin

You will have to set the AppDynamics for Databases installation directory as your current directory or use a full path to execute the mysqldump.exe utility.

For AppDynamics for Databases, the default username is "pw" and the default password is "pw".

Here is an example of the command to execute from the Windows or Linux command line:

mysqldump.exe -u pw -ppw -P 8091 -c --no-create-info dbtuna > appd4db-backup.sql

Parameters are as follows:

This utility outputs to stdout, so you can use any piping mechanism that makes sense for you (e.g. file, zip, remote, etc.). Adjust names and paths accordingly.