HPOS 3.4.1 Backing up and Restoring HP Output Server, Version 3.4.1

HP Output Server 3
Backing up and Restoring HP Output Server, Version 3.4.1
Backing up HP Output Server on a UNIX host
Task 2: Backing up HP Output Server databases
HP Output Server stores configuration settings and records in several MySQL databases. This section describes how
to back up HP Output Server databases and tables in an installation of MySQL for HP Output Management on a
UNIX host. This section provides instructions for performing the following types of backups:
• backing up all databases
• backing up more than one specified database
• backing up a single database
• backing up specified tables within a single database
CAUTION: Before you create a copy of HP Output Server databases, ensure that all HP Output
Server servers are stopped.
Backing up all databases
To back up all the databases, including the database tables and records for each database, type the following
commands:
cd mySQLinstallDir/bin
./mysqldump --defaults-file=mySQLinstallDir/my.cnf --quote-names
--add-drop-table --quick --extended-insert --all-databases
--result-file=/path/fileName
where
- mySQLinstallDir is the location of the MySQL for HP Output Management installation.
- path is the location you choose for saving the backup of the databases.
- fileName is a name for the file that will save a copy of the databases and their contents.
Backing up more than one database
You can back up more than one specified database by using the --databases option instead of
--all-databases in the preceding commands and by specifying the names of the databases to back up.
All databases and tables are created in the MySQL mySQLinstallDir/data directory, where mySQLinstallDir is the
installation path for MySQL for HP Output Management. Each server’s database name is prepended with the
DAZELNS values of the domain name and port number. For example, if the PM database has a DAZELNS value of
DAZEL:athena.d,edwina.hp.com[4009], the PM database name is athena!d_4009_pm.
NOTE: The database name replaces the period in the domain name with an ! (exclamation)
because the period is a database/table delimiter in MySQL.
The following example creates a backup of the databases named sluggo!d_4009_pm, sluggo!d_4009_em,
and sluggo!d_4009_ids_ccm. MySQL for HP Output Management is installed in /usr/local/mysql and
the backup file is located at /mybackup/myDBs
cd /usr/local/mysql/bin
./mysqldump --defaults-file=/user/local/mysql/my.cnf --quote-names
--add-drop-table --quick --extended-insert --databases
sluggo!d_4009_pm sluggo!d_4009_em sluggo!d_4009_ids_ccm
--result-file=/mybackup/myDBs