HP 3PAR System Reporter 3.1.0 Software User's Guide (QL226-96645, December 2012)

Figure 67 Microsoft Office Excel Internal Error
If you experience a problem with a recovered copy of the workbook (Figure 68 (page 220)), try
starting with a fresh copy of System Reporter workbook.
Figure 68 Microsoft Excel Recovery Error
Extracting Data from the Database with sysbck
Sometimes it is necessary to extract some of the data from the System Reporter database. For
example, you may want to send that data to HP to help in analyzing a performance problem. This
section describes how you can extract all or some of the data from a database using the sysbck
command into a set of files that can then be loaded into a different database.
NOTE: If necessary, when using sysbck to extract large amounts of data from a database, the
contents may be saved in separate 2 Gb files.
NOTE: The sysbck command is recommended when extracting a relatively small sampling of
the database. The command creates a file with SQL statements to insert each row of extracted
data into a database. While this is convenient for subsequently loading the data into a database,
especially if the database is of a different type than the source database, the file size can be quite
large. If you want to extract the entire database or large sections of the database, it is preferable
to dump the entire database as described in “Dumping the Entire Database” (page 224).
On Windows the sysbck.exe executable is installed in the System Reporter directory (by default
C:\Program Files\3PAR\System Reporter), and on Linux the sysbck.bin executable
is installed in the /usr/bin/ directory.
The parameters for the sysbck command are shown below:
# ./sysbck.binUsage:
sysbck [parameters]
The [parameters] are
-dbtype <dbtype> Type of database: sqlite, mysql or oracle.
-dbhost <dbhost> For mysql: name or IP address of host.
Default is localhost.
220 Troubleshooting System Reporter