![](/images/backgrounds/286310/hp-3par-system-reporter-e-media-kit-users-manual-156017363x1.png)
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
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