
Setting Up vFoglight 95
Backing Up, Upgrading, and Restoring vFoglight
• database_name is the database name, as configured by the
foglight.database.name parameter in <vfoglight_home>/config/
foglight.config.
•
database_port_number is the database port number, as configured by the
foglight.database.port parameter in <vfoglight_home>/config/
foglight.config.
•
backupfile_name is the name of the backup SQL file.
3
After the backup SQL file is created, stop the MySQL database by issuing the
shutdownDb.bat command from the <vfoglight_home>/bin directory.
4
Verify that the database is down by verifying that the database process,
mysqld.exe, is no longer running using the Task Manager.
The backup of the MySQL database is now complete.
Note vFoglight Management Server ships with the InnoDB Hot Backup
®
tool. You can use
this tool to back up an embedded MySQL database as an alternative to the above
procedure. For information on how to use this tool, see “To back up an embedded
MySQL database using the InnoDB Hot Backup tool:” on page 95.
To back up an embedded MySQL database using the InnoDB Hot Backup tool:
1
Create a directory structure that will contain the backup files.
You can create a master directory with two subdirectories: one that stores
configuration files that will be used by the InnoDB Hot Backup tool, and another
one, that stores the backup files. For example:
• <vfoglight_home>/backup/config
• <vfoglight_home>/backup/data
Where vfoglight_home contains the path to the vFoglight installation directory.
For example, its default location on Windows is C:\Vizioncore\vFoglight.
2
Create two configuration files for the InnoDB Hot Backup tool, each containing
the information about
• the data that is to be backed up:
my.cnf
• the backup location:
backup.cnf
Open a text editor and create the two configuration files using the following
syntax.
my.cnf
datadir="vfoglight_home/mysql/data"
innodb_data_home_dir="vfoglight_home/mysql/data"
innodb_data_file_path=ibdata1:10M:autoextend
Comentarios a estos manuales