Filter
Top Products
ETV Portal Server Admin Guide 117
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.
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.
T To 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.
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.