Deployment Guide

80 Foglight
Installation and Setup Guide
Before You Begin
The instructions in this chapter assume that you have already installed vFoglight. If you
have not, see “Installing vFoglight” on page 31 for installation instructions.
Migrating Data from an Existing Database
The contents of the MySQL database can be copied to another MySQL instance via an
export/import cycle. The following procedure performs a full export of the database.
This procedure can be run against a database currently in use by a server.
To export and import a MySQL database:
1 Run the following command from the MySQL command shell:
mysqldump -u<username> -p<password> -h<hostname> -P<port> --
databases <database name> > backup.sql
The -h parameter can be omitted if the database is on the same host.
2 Import the database using the following syntax:
mysql -u<username> -p<password> -P<port> < backup.sql
The import process recreates the tables in the database. Therefore, any data that
was in the destination environment prior to the import is lost.
Caution The vFoglight servers must be stopped during the import process.
Note When moving a database between environments, care should be taken to ensure that the
vFoglight schema version is lower or equal to the vFoglight server in the destination
environment as an upgrade to a new schema is possible (run foglight_db_upgrade.bat|sh or
start server with -Dfoglight.database.upgrade=true).