Sandbox

From Fishbowl
Jump to navigation Jump to search

In many circumstances, it may be helpful to experiment with a duplicate Sandbox copy of your database so that you don't have to worry about messing up your Live database. There are a few ways to do this depending on your needs. Listed below are the three methods that will be covered in this article.

  • 1 computer - 1 database at a time: You can have your Live database and your Sandbox database on the same computer with the same Fishbowl installation. When you need to access the Sandbox database, you will temporarily stop the Live database and switch to the Sandbox database.
  • 2 computers - 2 simultaneous databases: If you need to be able to access both databases simultaneously, you can install the Fishbowl Server again on a different computer. Then when you need to access the Sandbox database, you start the Fishbowl Server on the new computer. Any Fishbowl Client on the network can then see both databases and choose which database to use.
  • 1 computer - 2 simultaneous databases: If you need the Sandbox database to be running simultaneously on the same computer as the Live database, you will install the Fishbowl server in a new directory and have the Sandbox database running on a different port than the Live database. Any Fishbowl Client on the network can then choose which database to connect to by entering the corresponding port number.

Click one of the blue links above to see the complete list of instructions for the method that you choose or use the links below to jump to a specific section.




















1 computer - 1 database at a time

Backup

  1. To create a backup, right-click the Fishbowl Server icon in the system tray and select Options.
    Server Options Wide.png
  2. Right-click your Live database and select Backup Database
    MySQL backup.png
  3. The backup file will be saved in the Fishbowl\data\backups folder. For example, C:\Program Files\Fishbowl\data\backups
    Successful backup.png
  4. Close the Fishbowl Server Administration window.
    Close Fishbowl Server Administration.png

Restore

  1. On the server computer, double-click the Fishbowl Server icon in the system tray and then click the Stop button.
    Fishbowl Server Stop.png
  2. When the server is fully stopped, the Server Status window will automatically close.
    Fishbowl Server Stopped.png
  3. Click the Tools menu and select Options.
    Server Tools Options.png
  4. Click the Restore tab and then click the Find File Button.png Find File button.
    If the Find File Button.png Find File button is disabled, close the window to make sure the Fishbowl Server is fully stopped and then try again.
    Restore database.png
  5. Browse to the location of the backup file, select the file, and then click Open.
    Select backup file.png
  6. In the Database field, change the database name to Sandbox.
    Name Sandbox Database.png
  7. Click the Restore button and then click Yes to confirm that the process may take a few minutes.
    Restoring Database.png
  8. Once the Sandbox database has been created, click OK in the confirmation window.
    Restored Database.png
  9. Click the Database tab and make sure the Sandbox database is selected and then click OK.
    Select Restored Database.png
  10. After you get a message that the database has been changed to the Sandbox database, click OK.
    Changed database confirmation.png
  11. Click the Start button.
    Fishbowl Server Start.png
  12. When the server is fully started, the Server Status window will automatically close.
    Fishbowl Server Started.png
  13. Close the Fishbowl Server window.
    Close Fishbowl Server.png

Rename

  1. Open any Fishbowl Client and connect to the new database. Because the address and port are the same, nothing needs to be changed in the login window.
  2. Open the Icon.Company.png Company module and change the company name so that you can distinguish between the two databases.
    Sandbox Company Name.png
  3. You will need to stop and then start the Fishbowl server to apply the name change. Right-click the Fishbowl Server icon in the system tray and click Stop.
    Stop Server Wide.png
  4. Right-click the Fishbowl Server icon in the system tray and click Start to apply the name change.
    Start Server Wide.png

Connect

  1. Open any Fishbowl Client and click the Details button in the login window. Click the Find File Button.png Find Server button and then click the drop-down arrow to verify the correct database is selected.
    Sandbox login.png






















2 computers - 2 simultaneous databases

Backup

  1. To create a backup, right-click the Fishbowl Server icon in the system tray and select Options.
    Server Options Wide.png
  2. Right-click your Live database and select Backup Database
    MySQL backup.png
  3. The backup file will be saved in the Fishbowl\data\backups folder. For example, C:\Program Files\Fishbowl\data\backups
    Successful backup.png
  4. Close the Fishbowl Server Administration window.
    Close Fishbowl Server Administration.png
  5. Copy the backup file to the second computer that will be running the Fishbowl Server.

Install

  1. On the second computer, download the latest version of the Fishbowl installer.
  2. Install Fishbowl on the second computer.
  3. On the Installation Mode step of the installer, select Current Fishbowl User and select Server with Client.
    Installation Mode.png
  4. On the Select Destination Directory step of the installer, change the destination directory to Fishbowl Sandbox.
    New Server Directory.png
  5. Enter your license key and proceed through the installation wizard.
  6. On the final step, make sure Run Fishbowl is selected and then click Finish.
    Run Fishbowl.png
  7. If you get a message saying that there is no database yet, you can skip the first three steps in the next section.
    No database.png

Restore

  1. On the second computer, double-click the Fishbowl Server icon in the system tray and then click the Stop button.
    Fishbowl Server Stop.png
  2. When the server is fully stopped, the Server Status window will automatically close.
    Fishbowl Server Stopped.png
  3. Click the Tools menu and select Options.
    Server Tools Options.png
  4. Click the Restore tab and then click the Find File Button.png Find File button.
    If the Find File Button.png Find File button is disabled, close the window to make sure the Fishbowl Server is fully stopped and then try again.
    Restore database.png
  5. Browse to the location of the backup file, select the file, and then click Open.
    Select backup file.png
  6. In the Database field, change the database name to Sandbox.
    Name Sandbox Database.png
  7. Click the Restore button and then click Yes to confirm that the process may take a few minutes.
    Restoring Database.png
  8. Once the Sandbox database has been created, click OK in the confirmation window.
    Restored Database.png
  9. Click the Database tab and make sure the Sandbox database is selected and then click OK.
    Select Restored Database.png
  10. After you get a message that the database has been changed to the Sandbox database, click OK.
    Changed database confirmation.png
  11. Click the Start button.
    Fishbowl Server Start.png
  12. When the server is fully started, the Server Status window will automatically close.
    Fishbowl Server Started.png
  13. Close the Fishbowl Server window.
    Close Fishbowl Server.png

Rename

  1. On the second computer, open a Fishbowl Client.
  2. On the login window, click the Details button to verify that the Server Address says localhost. This means you will be connecting to the Sandbox server that you just installed on the second computer.
    Login localhost.png
  3. Open the Icon.Company.png Company module and change the company name so that you can distinguish between the two databases.
    Sandbox Company Name.png
  4. You will need to stop and then start the Fishbowl server to apply the name change. Right-click the Fishbowl Server icon in the system tray and click Stop.
    Stop Server Wide.png
  5. Right-click the Fishbowl Server icon in the system tray and click Start to apply the name change.
    Start Server Wide.png

Connect

  1. Open any Fishbowl Client and click the Details button in the login window. Click the Find File Button.png Find Server button and then click the drop-down arrow to verify the correct server/database is selected.
    Sandbox login.png






















1 computer - 2 simultaneous databases

Backup

  1. To create a backup, right-click the Fishbowl Server icon in the system tray and select Options.
    Server Options Wide.png
  2. Right-click your Live database and select Backup Database
    MySQL backup.png
  3. The backup file will be saved in the Fishbowl\data\backups folder. For example, C:\Program Files\Fishbowl\data\backups
    Successful backup.png
  4. Close the Fishbowl Server Administration window.
    Close Fishbowl Server Administration.png

Install

  1. On the server computer, download the latest version of the Fishbowl installer.
  2. Install Fishbowl on the server computer.
  3. On the Installation Mode step of the installer, select Current Fishbowl User and select Server with Client.
    Installation Mode.png
  4. On the Select Destination Directory step of the installer, change the destination directory to Fishbowl Sandbox.
    New Server Directory.png
  5. Enter your license key and proceed through the installation wizard.
  6. On the final step, make sure Run Fishbowl is selected and then click Finish.
    Run Fishbowl.png
  7. If you get a message saying that there is no database yet, you can skip the first three steps in the next section.
    No database.png

Restore

  1. On the server computer, double-click the Fishbowl Server icon in the system tray and then click the Stop button.
    Fishbowl Server Stop.png
  2. When the server is fully stopped, the Server Status window will automatically close.
    Fishbowl Server Stopped.png
  3. Click the Tools menu and select Options.
    Server Tools Options.png
  4. Click the Restore tab and then click the Find File Button.png Find File button.
    If the Find File Button.png Find File button is disabled, close the window to make sure the Fishbowl Server is fully stopped and then try again.
    Restore database.png
  5. Browse to the location of the backup file, select the file, and then click Open.
    Select backup file.png
  6. In the Database field, change the database name to Sandbox.
    Name Sandbox Database.png
  7. Click the Restore button and then click Yes to confirm that the process may take a few minutes.
    Restoring Database.png
  8. Click the Server tab and change the port number to 28193.
    Server Administration.png
  9. Click the Database tab and make sure the Sandbox database is selected and then click OK.
    Select Restored Database.png
  10. After you get a message that the database has been changed to the Sandbox database, click OK.
    Changed database confirmation.png
  11. Click the Start button.
    Fishbowl Server Start.png
  12. When the server is fully started, the Server Status window will automatically close.
    Fishbowl Server Started.png
  13. Close the Fishbowl Server window.
    Close Fishbowl Server.png

Rename

  1. Open any Fishbowl Client and in the login window, change the Server Port to 28193 to connect to the Sandbox database.
    Client New Port.png
  2. Open the Icon.Company.png Company module and change the company name so that you can distinguish between the two databases.
    Sandbox Company Name.png
  3. You will need to stop and then start the Fishbowl server to apply the name change. Right-click the Fishbowl Server icon in the system tray and click Stop.
    Stop Server Wide.png
  4. Right-click the Fishbowl Server icon in the system tray and click Start to apply the name change.
    Start Server Wide.png

Connect

  1. Open any Fishbowl Client and click the Details button in the login window.
    Client New Port.png
  2. Use Server Port 28193 to connect to the Sandbox database
  3. Use Server Port 28192 to connect to the Live database
  4. Running two Fishbowl servers on the same computer requires more computing power. If the Sandbox database is only needed occasionally, you may consider shutting down the Sandbox server when it is not in use.