1 backing up sentral server and sentral console, 2 backing up sentral database schema, 3 backing up virtual machines and snapshots – ClearCube Sentral 6.9.3 User Manual
Page 31: 14 basic operations, Backing up sentral server and sentral console, Backing up sentral database schema, Backing up virtual machines and snapshots
Sentral Quick Start Guide
24
Rev F 2.2.08.06.2014
13.1 Backing up Sentral Server and Sentral Console
ClearCube recommends backing up Sentral Server and console after making all configurations.
From the C:\Program Files\ClearCube Sentral\ directory, back up the directories shown below:
ClearCube Sentral Console
Tomcat
13.2 Backing up Sentral Database Schema
ClearCube recommends creating an automated daily or weekly backup of the database schema.
You can create a batch file that gracefully stops the console and server, backs up the database, and then
restarts the Apache Tomcat service.
The example below is a script you can use with Windows Scheduler that backs up a MySQL database.
Example 1. A script to back up MySQL database
echo OFF
TASKKILL /F /IM "javaw.exe"
NET STOP "tomcat7"
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump" –u
-p
NET START "tomcat7"
Save the script above as a .bat file and schedule it to run using Task Scheduler, included with Windows
operating systems.
You can then use MySQL restore commands to restore the database if needed:
mysql --verbose --user=USERNAME --password=PASSWORD CMS < /PATH/TO/backupfilename.SQL>
13.3 Backing up Virtual Machines and Snapshots
When Sentral is installed on a virtual machine, it is a best practice to create a snapshot after completing all
Sentral configurations. The snapshot enables you to return to a known instance if it is ever necessary.
Additionally, it is a best practice to create backups of the Sentral Server virtual machine on a regular basis.
14 Basic Operations
The sections below provide instructions for basic Sentral tasks and explain how to install the Sentral
Host Agent on hosts (physical and virtual compute devices) that Sentral manages.