VBrick Systems ETV v4.1 manual Database Backup, Introduction

Chapter 9

Database Backup

Introduction

The EtherneTV Portal Server uses MySQL to manage the database of users and groups, and also the video information related to content on the VOD Servers. Note that this procedure backs up information in the MySQL database only. It does not back up any video content you may have stored on attached VOD servers. (To back up video content, you will likely need a backup strategy and a robust storage capability.) Use this procedure when removing the VOD server for troubleshooting purposes, or when upgrading the software, in order to avoid the loss of this content information. Use the backup procedure described here to ensure that data loss is minimal when you restore the database after a transfer or removal of VOD servers. This procedure can also be helpful for load balancing and failover. It can simplify the task of maintaining multiple servers with the same information.

Note In order to backup database files, you will need administrative access to the ETV Portal Server and a safe location to store the backup database and files.

Database Backup

To ensure a successful database backup, you must follow the exact sequence of steps shown below. Also, since this process will interrupt any streaming video, you may want to schedule this procedure at night or during non-business hours.

TTo back up the database:

1.Log into the Portal Server as the Administrator.

2.The MySQL Service will need to be stopped in order to have a clean copy of the

database. Go to Start > Control Panel > Administrative Tools > Services.

3.Right-click on MySQL in the right pane and select Stop. There will be a list of other services that will stop. Take note of these other services and select Yes.

4.The Service Control window will show the progress of the Services being stopped. After the services have stopped minimize the Services window.

5.Open My Computer and save copies of the following directories in a safe backup location.

C:\Program Files\MySQL\MySQL Server x.x\data

C:\Program Files\VBrick\MCS\Images\Thumbnails

C:\Program Files\VBrick\MCS\licenses

6.To restart the Services, maximize the Services window.

7.Right-click on the VBrick Object Starter and select Start. This will start the MySQL services. If the EtherneTV Scheduler Module or other services were stopped in Step 3 above they will need to be started as well.

ETV Portal Server Admin Guide 117