HP 3PAR System Reporter Software - Manual (Page 363)

11.13 Dumping the Entire Database
System Reporter 2.8 3PAR System Reporter User’s Guide
11.7.2 Dumping the Entire MySQL Database
To create a dump of a MySQL database use the mysqldump program as follows
This creates a text file called dbname.sql that contains SQL commands to create the tables
and insert the data into the tables. You can simply source this file into MySQL to recreate the
entire database.
NOTE: Ideally, when extracting data for 3PAR support from an SQLite database,
use sysbck without the default dbouttype parameter.
# mysqldump --host=hostname --user=username --password=passwd --opt dbname >
dbname.sql
NOTE: When dumping data from a large database that is to be backed up to a
different location than the source, it is best to use sysbck as the data will be
stored in multiple 2 Gb files (if necessary), and is easier to manage.