This guide walks you through restoring or moving your locally hosted Rock Gym Pro (RGP) database to a new server computer.

This process can be used for:

• Planned server replacements or upgrades
• Recovery after a server crash or hardware failure
• Situations where the original server is no longer accessible

If your original server has failed, you do not need access to the old server to restore your database, provided your facility was successfully sending offsite backups to Rock Gym Pro before the failure occurred.

Please read through the full guide before beginning.

Process Overview

Use the checklist below as a high-level overview of the restoration process.

• STEP 1 - Send in a Backup of Your RGP Database (if the server is accessible)
• STEP 2 - Install RGP and MySQL on the New Server
• STEP 3 - Create the New Database
• STEP 4 - Restore the Offsite Backup
• STEP 5 - Reconnect Workstations
• STEP 6 - Stop and Uninstall MySQL on the Old Server

Before You Begin

Please read through the following steps first before installing any software.
 

Things You Need Before Proceeding:

• RGP Encryption Key (created by the facility during your original RGP installation)

• MySQL Root Password (created by the facility during your original RGP installation)

• RGP Plan Activation Key and Online Group Key (provided to the facility during your original RGP installation)

• Static IP address that will be used on the new server

• Database name from your current server

• For multigyms, a working VPN with successfully tested connections

If you are missing any required keys or passwords, contact RGP Support before proceeding.

Important Networking Recommendation

If you are a multi-location facility, or a single facility with many workstations, it is strongly recommended to assign the new server the SAME static IP address as the old server.

Using the same IP address prevents workstations and remote locations from needing to be reconfigured manually.

If the server IP address changes:

• Local workstations will need to be updated
• Multi-location facilities may need to update VPN or Remote Database Control Panel settings

Critical Backup Requirement

This process restores your database from the RGP Offsite Backup Archive.

Your facility must have been successfully sending offsite backups to Rock Gym Pro before the server failure or migration occurred. If offsite backups were not configured or were failing prior to the outage, Rock Gym Pro may not have a recoverable copy of your database.

If your old server is still operational, we strongly recommend creating and uploading a fresh offsite backup before beginning the migration (See Step 1 below)

STEP 1 - Send in a Backup of Your RGP Database (if the server is accessible)

If your original server has crashed or is inaccessible, skip this step and continue to STEP 2.

If your old server is still running:

1. Create a fresh backup:
   1. Go to:
      Data Entry > Manage > Maintenance > Backup and Restore Database
   2. Click:
      Execute Backup Now
   3. Choose Yes to send the backup offsite
2. Confirm the backup uploaded successfully in the Offsite Archive tab.
3. Remove the Plan Activation Key and Online Group Key:
   • Data Entry > Manage > Settings
4. Stop the MySQL service:
   • Control Panel > Administrative Tools > Services
5. Disable MySQL from starting automatically and power down the old server.

STEP 2 - Install RGP and MySQL on the New Server

1. Download and install Rock Gym Pro by filling out this form to retrieve a download link: RGP Locally Hosted Download Form 

2. Open Data Entry and install: Microsoft C++ and MySQL ODBC Connector
   
   
    

3. After installing C++ and the ODBC Connector, open Data Entry again and click next in the wizard. 
4. Choose the option for New Installations and click the button to download the MySQL server.
   
   
   
    
5. After the MySQL server downloads, install it and then select the option at the end of the install to Configure your MySQL Server now. This will open the MySQL Server Instance Configuration Wizard.

Use all of the default settings for the MySQL server except for the following.  

• Multigyms, when installing and configuring MySQL Server, you must use the same MySQL Root password you created on your ORIGINAL installation of RGP on your “old server”. Email support@rockgympro.com if you need this information.

• - When going through the MySQL Configuration Wizard, please be sure to enable the options to Add firewall exception for this port and Enable Root Access from Remote Machines. 
  
  Besides for enabling these two settings, and entering your original MySQL database password, you can use the default options and click next through all of the screens of the MySQL Server Instance Configuration Wizard.
  
  Tick this box to Add the firewall exception for this port
  
  
  Enter your original MySQL Password here and tick the box to Enable Root Access from Remote Machines 
  
  
   

  You may need to install .NET on your new computer if so follow these instructions.
   

STEP 3 - Create the New Database

1. After configuring the MySQL Server, navigate back to the Rock Gym Pro Database Configuration Wizard and change your selection to "A compatible database server is running on THIS computer". 
   
   
    

2. Create a new/blank database on your new server, as if you are starting RGP from scratch, but use the same database name for your new database (more information below).

   You can find your database name (on your “old”/current server) via the Backup and Restore Window in Data Entry > Manage > Maintenance > Backup and Restore OR via RGP Configuration Wizard on any of your workstations. 
   
   To do this on a workstation, open the config wizard by searching for Config in the Windows search bar. It should suggest Configure - Rock Gym Pro. 
   
   Click the Next button until you get to this window to see your database name. Then cancel and close the config window.

   
    

3. After you have obtained this information you can configure your new server. Regardless of your facility name, at this step please enter in the Database name you just retrieved.

   
   
    

4. On this screen you will enter your MySQL root password. The username is root.
   
   
   
    
5. Next, choose the option that says I have already created a Rock Gym Pro database, and select your database from the drop down menu. Enter your encryption key on the next screen and then click the Start button to create the new blank database.
   
   
   
   
    
6. IMPORTANT > After you've created the database, run the MySQL Configuration Utility tool as outlined in this support article: Running the MySQL Configuration Utility.

STEP 4 - Restore the Offsite Backup

IF YOUR FACILITY IS ON AN RGP PAID PLAN AND YOU ARE RESTORING FROM YOUR RGP ARCHIVED OFFSITE BACKUP:

1. After you have installed RGP, MySQL ODBC driver/connector, and the MySQL Server 5.0, follow the steps below.
2. Go to Data Entry > Manage > Settings and enter in your RGP Plan Activation Key ONLY. DO NOT ENTER THE ONLINE GROUP KEY.  
   
   If you did not save your RGP Plan Activation Key and/or Online Group Key, please contact support@rockgympro.com to obtain this information. 

DO NOT ENTER THE ONLINE GROUP KEY, as you will NEED TO RE-ENTER your RGP Plan Activation Key after your data has been restored. At that time, after your restore, you will enter the Online Group Key.

1. Next go to Data Entry > Manage > Maintenance > Backup and Restore Database and Click the OFFSITE ARCHIVE Tab. From there, select the most recent backup from the Offsite Archive list and press RESTORE.

After you have restored the Offsite Archive, close the Backup and Restore window. RGP will “ask” you to confirm you have performed the following steps after your have restored your database:

Update Stripe Payment Gateway Configuration

If your facility uses Stripe for billing and/or point of sale processing, verify the Stripe connection after restoring the server.

Billing Credit Card Processing (Stripe Standard or Stripe Custom)

1. Go to:
   Data Entry > Manage > Settings > Payment & Billing Tab
2. Select:
   Stripe | www.stripe.com
   from the drop-down menu beside Billing Credit Card
3. Click:
   Configure
4. Click:
   Check Stripe Configuration

Point of Sale Processing (Stripe Custom Only)

If your facility uses Stripe Custom Terminals for point of sale processing:

1. Go to:
   Data Entry > Manage > Settings > Payment & Billing Tab
2. Select:
   Stripe Terminal
   from the drop-down menu beside Point of Sale
3. Click:
   Configure
4. Select your terminal

If the configuration check fails or Stripe does not connect successfully, please contact RGP Support for assistance.

Step 5: Reconnect Workstations

Finally, verify your workstations are connecting to your NEW server. Go to a workstation and open Data Entry, if Data Entry opens, then you are connected and you do not need to point your workstations to the new server.

If you don't have a dedicated IP, or the server IP changed, or if you are using the server name to connect, you will need to point all your RGP workstations to the new server via the Rock Gym Pro Configuration Wizard. 

1. On each workstation, search in in the Windows search bar for Config, it should suggest Configure - Rock Gym Pro. Otherwise, you can open this by navigating to C:\Program Files (x86)\Rock Gym Pro and clicking on Config.

2. After opening Configure - Rock Gym Pro, click the button for the advanced setup and say yes to skip the wizard.

3. Edit the Database Server field and enter either the new IP address, if dedicated, or the new server's name. Click OK to save the new connection information and then boot RGP to test the connection.

Note: To find the server name, search for About this PC in the Windows search bar on the server machine. The server's name is listed at the top under Device Name.



 

Step 6 - Stop and Uninstall MySQL on your old server.  IMPORTANT!

It is critical that MySQL is stopped and uninstalled on your old server.  This will prevent workstations from accidentally connecting to this database and causing grief.  Additionally, if Rock Gym Pro is launched on the old server it will download waivers and online transactions and cause all sorts of grief.

If you do not follow these steps exactly, then MySQL will NOT be uninstalled and may cause issues if you use your “old” server as an RGP workstation in your facility.

If you have not already done so, perform the following on your original server machine.

1. On your old server go to the Control Panel > Administrative Tools > Services. 
2. Locate MySQL and select Stop the service.

Next, after stopping the Service, you can uninstall MySQL using the steps below:

1. Control Panel > Programs and Features > Locate MySQL Server 5.0, Right-click and select uninstall. Perform the same steps for Rock Gym Pro and the MySQL ODBC Connector.
2. After the MySQL Server and RGP have finished uninstalling, find and delete their folders.
3. The server folder should be located on the C drive. Navigate to C:\Program Files (x86) > MySQL > MySQL Server 5.0 Folder.
4. Right-click on the MySQL Server 5.0 Folder and select Delete. You may need Administrative privileges to delete the folder.
   
   
    
5. The RGP folder is typically located in C:\Program Files (x86)\Rock Gym Pro, but it could also be in C:\Program Files\Rock Gym Pro. Find and delete this folder.
6. Finally, search for Command Prompt in the Windows search bar and open it as Administrator. Enter the following command and press enter. 
   
   sc delete mysql
   
   
   
   You should get a success message. Do it again to be sure and it will say it can't find MySQL.
   Now that the computer has been cleaned of MySQL, you can use the machine as a workstation.
   
    

Final Steps and Additional Information: 

Reconfigure Offsite Backups

After restoring the server, backup scheduling must be configured again:

• Configure local backups in RGP
• Configure Windows Task Scheduler to send backups offsite

Re-enable Replication

Go to:

• Data Entry > Manage > Maintenance > Database Replication

Replication helps:

• Protect against data loss
• Support RGP Web/Mobile Dashboard features

Additional Requirements

If using the digital waiver system:

• Internet Explorer 10 or later is required
• All computers must have the correct date, time, and timezone
• All RGP systems must have access to:
  • app.rockgympro.com
  • rockgympro.com
  • www.rockgympro.com
  • s3.amazonaws.com