MySQL database backup and restore

Products

• VMware Smart Assurance

Issue/Introduction

MySQL database backup and restore.

Environment

 Watch4Net/M&R-7.0 to 7.5

Resolution

Backup Steps:

1. Stop Backend and MySQL service.
2. Copy all the files in this folder or copy the folder APG/Databases/MySQL/Default/data to a secure location. This Data folder has mysql db tables, data and indexes stored as three different files. (tablename.FRM, tablename.MYD, tablename.MYI).
3. Ensure all files have permissions and owner set as apg.

 

Recovery Steps:

1. Stop Backend and MySQL service.
2. Take backup of APG/Databases/MySQL/Default/data folder in destination host and move the same to another location (later this can be removed once data re-stored properly).
3. Copy the backup folder (data) as mentioned in above steps to APG/Databases/MySQL/Default directory in the destination host.
4. Ensure all files have permissions and owner set as apg.
5. Start MySQL, verify MySQL service is started successfully.
6. Start Backend service.