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

4 Technical Note
Backing up and Restoring HP Output Server, Version 3.4.1
Backing up HP Output Server on a UNIX host
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.
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 /usr/local/mysql and the
backup file is located at /mybackup/myDBtables
cd /usr/local/mysql/bin
./mysqldump --defaults-file=/usr/local/mysql/my.cnf --quote-names
--add-drop-table --quick --extended-insert sluggo!d_4009_jqm 002 003
051 --result-file=/mybackup/myDBtables
NOTE: For a list of table names for HP Output Server databases, see the Installation and
Configuration Guide for HP Output Server.