Руководство По Обслуживанию для Cisco Cisco StadiumVision Mobile
© 2011 Cisco Systems, Inc. All rights reserved. This document is Cisco Internal Information.
Page 28 of 28
Backing Up Proof of Play Data
The proof of play data in the /var/sv/pofp/data directory gets backed up as
part of the nightly backup.
part of the nightly backup.
The dbDump files in the /var/sv/pofp/dbDump directory will be removed from
the disk after 60 days.
the disk after 60 days.
Cleaning Up Proof of Play Data
At the end of season, clean up all proof of play data as follows.
1. Clean up proof of play data on the disk.
You can remove directories and internal data from previous SV Director
releases (prior to R2.2). This data is stored in the directory as
"/var/sv/pofp/YYYYMMDD". However, DO NOT remove the
"/var/sv/pofp/bin" directory. This is where the CSV report tool is located
for Release 2.2.x.
releases (prior to R2.2). This data is stored in the directory as
"/var/sv/pofp/YYYYMMDD". However, DO NOT remove the
"/var/sv/pofp/bin" directory. This is where the CSV report tool is located
for Release 2.2.x.
Table 10.
Cleaning up data on the disk (release 2.2 and beyond)
Directory
Description
/var/sv/pofp/data
This is the actual data for each game. You may want to keep a backup copy.
/var/sv/pofp/dbDump
This is a daily database dump from the database and does not need to be saved.
However, DO NOT delete the directory itself.
However, DO NOT delete the directory itself.
2. Clean up proof of play data in the database.
There are no links between the iapps_pofp and the iapps_1 databases.
Therefore, once these databases are backed up, you can remove entries
in the following tables.
Therefore, once these databases are backed up, you can remove entries
in the following tables.
Table 11.
Cleaning up data in the database
Database
Tables
Description
iapps_pofp
pofp_data
pofp_script
pofp_state
pofp_script
pofp_state
The pofp_data table does not have any foreign key constraints. The
pofp_state table entries should removed before removing entries in
the pofp_script table.
pofp_state table entries should removed before removing entries in
the pofp_script table.
iapps_1
x_popstateinfo
x_popinfo
x_popinfo
Remove all entries in these tables.