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

HP Output Server 9
Backing up and Restoring HP Output Server, Version 3.4.1
Restoring HP Output Server on a Windows host
Backing up specified tables within a single database
You can also back up individual tables in a database using the preceding commands for backing up a single database
and by specifying the names of the tables to back up. This backup option can be used when, for example, your jobs
table for a JQM is large and has many retained jobs that are about to expire. Backing up all the tables in that database,
except for the jobs table, reduces the size of the backup.
The following example creates a backup of tables named 002, 003, and 051 in a database named
sluggo!d_4009_jqm. MySQL for HP Output Management is installed in C:\mysql and the backup file is
located at C:\mybackup\myDBtables
cd C:\mysql\bin
.\mysqldump --defaults-file=C:\mysql\my.cnf --quote-names
--add-drop-table --quick --extended-insert sluggo!d_4009_jqm 002 003
051 --result-file=C:\mybackup\myDBtables
NOTE: For a list of table names for HP Output Server databases, see the Installation and
Configuration Guide for HP Output Server.
Restoring HP Output Server on a Windows host
This section describes how to restore HP Output Server from a backup on a Windows host. For information about
restoring HP Output Server from a backup on a UNIX host, see “Restoring HP Output Server on a UNIX host”
on page 5.
This section assumes that you have created a backup of HP Output Server by performing the steps in “Backing up HP
Output Server on a Windows host” on page 6.
Restoring HP Output Server includes the following tasks:
1. recreating the databases from the backup
2. restoring the HP Output Server program and configuration files from the installDir backup
The following sections describe how to perform these tasks.
Task 1: Recreating the HP Output Server databases
Before you restore the program and configuration files for HP Output Server, you fix or recreate the databases.
Depending on the type of database backup that you created, use the following options to recreate the databases from
the backup.
CAUTION: Before you recreate HP Output Server databases from a backup, ensure that all HP
Output Server servers are stopped.