HP 3PAR System Reporter Software User Manual

Page 360

11.10

Extracting Data from the Database with sysbck

3PAR System Reporter User’s Guide

System Reporter 2.8

■

From SQLite to SQLite:

■

From SQLite to MySQL:

■

From SQLite to Oracle:

The following examples show how to use

sysbck

without any optional parameters (Note this

will extract .ins data in the mySQL format).

■

Backs up the entire database from Oracle:

sysbck -dbtype sqlite -db cliuser -dbouttype sqlite -scripttype both -

backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010

12:45:00" -endtime "07/14/2010" -inservname s074:s138

sysbck -dbtype Sqlite -dbhost istat -db cliuser -dbpwfile dbpwfile -

dbouttype mysql -scripttype both -backupfilename "c:/test/

test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010"

-inservname s074:s138

sysbck -dbtype sqlite -db cliuser -dbouttype oracle -scripttype both -

backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010

12:45:00" -endtime "07/14/2010" -inservname s074:s138

sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -

backupfilename "c:/test/test_20100713_1322PM"