User guide
Table Of Contents
- Contents
- 1 Introducing McAfee Quarantine Manager
- 2 Pre-Installation Information and Tasks
- 3 Quick Setup
- 4 Installing the Software
- Accessing the software
- Installing MySQL for McAfee Quarantine Manager 6.0
- Installing McAfee Quarantine Manager version 6.0
- Configuring your MySQL database
- Configuring your Microsoft SQL Server database
- Installing McAfee Quarantine Manager 6.0 DB Suite utility
- Testing your installation
- Uninstalling McAfee Quarantine Manager
- 5 Integrating with ePolicy Orchestrator 4.0
- Before you begin
- ePolicy Orchestrator agent
- Installation
- Configuring policies for McAfee Quarantine Manager
- Introducing ePolicy Orchestrator 4.0 dashboard
- Reporting
- Systems
- Uninstalling the McAfee Quarantine Manager
- 6 Types of Interfaces
- 7 Getting Started with the Interface for administrators
- 8 Managing Quarantined Items
- 9 Managing Blacklists and Whitelists
- 10 Managing User Submissions
- 11 Managing Settings and Diagnostics
- 12 Managing administrators
- 13 Getting Started with the Interface for Users
- 14 About DB Suite Utility
- 15 Frequently Asked Questions
- Index
87
McAfee
®
Quarantine Manager
™
6.0 User Guide About DB Suite Utility
Archiving or Retrieving the existing MySQL database
14
Archiving or Retrieving the existing MySQL database
You can archive or retrieve the existing MySQL database only using command line
arguments given below:
To backup or archive the existing database:
1 Click
Start | Run, type services.msc, then click OK.
2 From the Services window, stop the McAfee Quarantine Manager service.
3 From the command prompt, go to the bin directory of MySQL installation folder.
4 Execute the following command:
mysqldump --complete-insert -n --add-drop-table -R <Database> -u
<DatabaseUser> -p<DatabaseUserPassword> -r "<CompletePathofBackupFile>"
For example: If the Database name is mqm, Database user is root, password is calangute, and
backup file is C:\Backups\MQM\MQM60Backup.sql, use the following command:
mysqldump --complete-insert -n --add-drop-table -R mqm -u root -pcalangute
-r "C:\Backups\MQM\MQM60Backup.sql"
To retrieve or restore the existing database:
1 Click Start | Run, type services.msc, then click OK.
2 From the Services window, stop the McAfee Quarantine Manager service.
3 From the command prompt, go to the
bin directory of MySQL installation folder.
4 Execute the following command:
mysql -e "source <CompletePathofBackupFile>" -u <DatabaseUser>
-p<DatabaseUserPassword> <Database>
For example: If the Database name is mqmv6, Database user is scott, password is tiger, and
backup file is C:\Backups\MQM\MQM60Backup.sql, use the following command:
mysql -e "source C:\Backups\MQM\MQM60Backup.sql" -u scott -ptiger mqmv6
To schedule a task to backup the existing database
1 Create a batch file with the following information:
md c:\backups\%DATE%\
cd c:\backups\%DATE%\
<InstallPath>\bin\mysqldump.exe --complete-insert -n --add-drop-table -R
<database-name> -u <username> -p<password> -r "MQM60Backup.sql"
2 Click Start | Control Panel | Scheduled Tasks | Add Scheduled Task.
3 Click
Next and browse for the batch file created in Step 1.
4 Click
Next.
5 Follow the on-screen instructions to schedule the task and complete the wizard.