Proper procedure for upgrading vFog embedded mySQL to 64bit?

This guide details the process starting on page 42

http://edocs.quest.com/foglight/565/files/Foglight_Install_WindowsEmbeddedMySQL.pdf

Appendix: Switching from an Embedded

to an External Database

You may find a performance improvement in Foglight if you use an external database.

This section describes how to migrate from using an embedded MySQL database with the

Management Server to using an external MySQL database.

1 Stop the Management Server.

2 Start the embedded database manually:

\bin\runDb.sh

3 Export the database content:

\mysql\bin\mysqldump -uroot -p [password] --port=13306 --

databases foglight > \foglight.dump

4 Shut down the database:

\bin\shutdownDb.sh

5 Connect to the external MySQL instance via MySQL:

\mysql\bin\mysql -h [mysql host] -P [mysql port] -u root -p

6 Create the Foglight database instance by running:

mysql> source \scripts\sql\mysql_create_db.sql

7 Re-import the data dump:

mysql> source \foglight.dump

8 Configure the Management Server to use this new database by opening the following file:

\config\server.config

9 Update the following values in the above file:

server.database.host = "[mysql host]";

server.database.port = "[mysql port]";

server.database.embedded = "false";

10 Remove the part of your Foglight installation that was used for the embedded MySQL

database by deleting the directory \mysql.

11 Restart the Management Server.

12 Verify that the Management Server starts successfully:Foglight: Installation and Setup Guide 43

Appendix: Switching from an Embedded to an External Database

a Open the most recent Management Server log file in \logs.

b Look for the message Forge Server startup completed and ensure that there are no

errors listed after it.

13 Verify that the Management Server connects to the migrated external MySQL database.

There are two ways to do so:

• Open the most recent Management Server log file in \logs. Verify that

the parameter server.database.host lists your external MySQL database host as its

value and that server.database.embedded is set to false.

• Log in to the browser interface and navigate to Dashboards > Administration > Setup

& Support > Foglight configuration. Verify that your external MySQL database host is

listed in the Database Host box and that External is listed in the Database Location box.