#--------------------------------------------------------------------------------------------------
#   AppDynamics controller metadata backup script
#--------------------------------------------------------------------------------------------------
#    This script will perform a metadata backup of the AppDynamics controller database to a
#    file.  The contents of the backup excludes metrics, events, snapshots and summary statistics,
#    which comprise the largest portion of the database.  All other tables, which make up the
#    controller metadata are included in the backup.
#
#	Modifications:
#
#     1) Set or replace $appd_install_dir with the path to the installation directory
#          for AppDynamics.  Alternatively, execute mysqldump from the following directory:
#              [appd_install_dir]/db/bin
#
#     2) Replace [password] with the root password for the AppDynamics controller
#          MySQL database.  This password may have been set at the time of installation.
#          Otherwise, this password may be found in the file:
#              [appd_install_dir]/db/.rootpw
#          if so then you can use --password=$(<$appd_install_dir/db/.rootpw) instead
#
#     3) (Optional) Specify the database port if different from the default 3388.
#
#     4) Set the pathname and file name of the generated SQL dump file in the last
#          line of this script
#
#--------------------------------------------------------------------------------------------------

# VERSION updated for v4.3 controllers

$appd_install_dir/db/bin/mysqldump --user=root --password=[password] --protocol=TCP --port=3388 \
--routines \
--ignore-table=controller.metricdata_min \
--ignore-table=controller.metricdata_min_agg \
--ignore-table=controller.metricdata_min_agg_app \
--ignore-table=controller.metricdata_ten_min \
--ignore-table=controller.metricdata_ten_min_agg \
--ignore-table=controller.metricdata_ten_min_agg_app \
--ignore-table=controller.metricdata_hour \
--ignore-table=controller.metricdata_hour_agg \
--ignore-table=controller.metricdata_hour_agg_app \
--ignore-table=controller.requestdata_summary \
--ignore-table=controller.requestdata_exitcall \
--ignore-table=controller.requestdata_properties \
--ignore-table=controller.eventdata_min \
--ignore-table=controller.eventdata_detail \
--ignore-table=controller.eventdata_affected \
--ignore-table=controller.eventdata_correlation_key \
--ignore-table=controller.eventdata_property \
--ignore-table=controller.eventdata_archive_property \
--ignore-table=controller.process_snapshot_bt_calls \
--ignore-table=controller.process_snapshot_properties \
--ignore-table=controller.process_snapshot_summary \
--ignore-table=controller.process_snapshot_archive_bt_calls \
--ignore-table=controller.process_snapshot_archive_summary \
--ignore-table=controller.machine_snapshot_summary \
--ignore-table=controller.machine_snapshot_archive_summary \
--ignore-table=controller.top_summary_stats \
--ignore-table=controller.top_summary_stats_app_five_min \
--ignore-table=controller.top_summary_stats_app_half_day \
--ignore-table=controller.top_summary_stats_app_one_hour \
--ignore-table=controller.top_summary_stats_detail_string_map \
--ignore-table=controller.top_summary_stats_half_day \
--ignore-table=controller.top_summary_stats_one_hour \
--ignore-table=controller.top_summary_tier_one_hour \
--ignore-table=controller.top_summary_stats_tier_five_min \
--ignore-table=controller.top_summary_stats_tier_half_day \
--databases controller $(cd $appd_install_dir/db/data; ls -d mds* eum* 2>/dev/null) > /tmp/AppDynamicsBackups/appdynamics_metadata_backup.sql