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

8 Technical Note
Backing up and Restoring HP Output Server, Version 3.4.1
Backing up HP Output Server on a Windows host
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 C:\mysql and the backup
file is located at C:\mybackup\myDBs
cd C:\mysql\bin
.\mysqldump --defaults-file=C:\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=C:\mybackup\myDBs
Backing up a single database
You can also create a backup of a single HP Output Server database, including all tables and records in the database,
by typing the following commands:
cd mySQLinstallDir\bin
.\mysqldump --defaults-file=mySQLinstallDir\my.cnf --quote-names
--add-drop-table --quick --extended-insert databaseName
--result-file=\path\fileName
where
- mySQLinstallDir is the location of the MySQL for HP Output Management installation.
- databaseName is the name of an HP Output Server database, for example, sluggo!d_4009_pm.
- path is the location you choose for saving the backup of the database.
- fileName is a name for the file that will save a copy of the database and its contents.