VBrick Systems Portal Server ETV v4.2 - Manual (Page 137)

ETV Portal Server Admin Guide 125
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\Logs
C:\Program Files\VBrick\MCS\Images\Thumbnails
C:\Program Files\VBrick\MCS\MCSPresentations
C:\Program Files\VBrick\MCS\Presentations
C:\Program Files\VBrick\MCS\StationIcons
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.