HP System Reporter Media Kit manual 11.13, Dumping the Entire MySQL Database

System Reporter 2.8 3PAR System Reporter User’s Guide

NOTE: Ideally, when extracting data for 3PAR support from an SQLite database, use sysbck without the default dbouttype parameter.

11.7.2 Dumping the Entire MySQL Database

To create a dump of a MySQL database use the mysqldump program as follows

#mysqldump --host=hostname --user=username --password=passwd --opt dbname > dbname.sql

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: 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.

Dumping the Entire Database

11.13