Examples of using sysbck for various databases – HP 3PAR System Reporter Software User Manual
Page 228
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 231)
.
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
-dbhost
Default is localhost.
For oracle: hosts string.
Ignored if dbtype is sqlite.
-db
For SQLite this is the full file name, including the path,
of the file that contains the database.
-dbpwfile
password for the database.
Ignored if dbtype is sqlite.
-dbouttype [Optional]
-scripttype [Optional]