Master database backup

Products

• VMware Smart Assurance

Issue/Introduction

• Steps to backup the master database.
• How can we export and import the mysql master database.

Environment

Watch4net|M&R - 7.x

Resolution

PFB the commands:

Export:

/APG_HOME/Databases/MySQL/Default/bin/mysqldump --user=root -p master --socket /APG_HOME/Databases/MySQL/Default/data/mysql.sock > master-backup.sql

Import:

/APG_HOME/Databases/MySQL/Default/bin/mysql -u root -p master --socket /APG_HOME/Databases/MySQL/Default/data/mysql.sock < master-backup.sql

 

NOTE:

1). On import "DROP TABLE IF EXISTS" command is run for each table in the database. You can view master-backup.sql file to verify the same.

2). It is recommended to test these commands in the test environment before implementing in the production.