Cisco Systems Unified Videoconferencing Manager manual Backing Up the Internal Database, Procedure

Chapter 2 Backing up and Restoring Cisco Unified Videoconferencing Manager Data

How to Back up Cisco Unified Videoconferencing Manager Data

How to Back up Cisco Unified Videoconferencing Manager Data

•Backing Up the Internal Database, page 2-2

•Backing Up an MSSQL 2005/2000/MSDE Database, page 2-2

•Back-up File Locations for Configuration Files, page 2-3

•Backing Up Branding and Sound Files, page 2-4

•Backing Up the License, page 2-4

Backing Up the Internal Database

Procedure

Step 1 Open a DOS window and go to the MySQL bin directory located by default at one of the following locations:

C:\Program Files\MySQl\mysql-4.0.21-win\bin, or

C:\MySQl\mysql-4.0.21-win\bin

Step 2 Run the following DOS command to export the contents of the internal database to a file called mydump:

mysqldump -u root --all-databases --add-drop-table --single-transaction > mydump

Step 3 Save the mydump file to a safe location.

Backing Up an MSSQL 2005/2000/MSDE Database

This section is only relevant if your Cisco Unified Videoconferencing Manager installation is using an external MSSQL database. For demonstration purposes, we assume the installed Cisco Unified Videoconferencing Manager database name is “temp_db” and that the database owner is “temp_user”.

You can modify the database name and its owner name during the installation process.

Procedure

Step 1 Use Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Enterprise Manager Management Studio to access temp_db.

MSDE database does not include a management console by default. You need to use an external management console to connect to a MSDE database.

Step 2 Right-click temp _db and select All Tasks > Backup Database, or Task > Backup to create a database backup file.

Assume the name of the backup file is “temp_db.bak”.

Step 3 Save temp_db.bak to a safe location.

Installation Guide for Cisco Unified Videoconferencing Manager Release 5.6

2-2 OL-16908-01