Fishbowl Security Basics


  1. There seems to be a lot of information about backing up, but I can’t seem to find anything about restoring from that backup. For example – can I choose to just restore certain elements (ie a deleted BOM) or do I have to completely overwrite the whole database?

  2. Great question Lisa! There really isn’t much documentation on restoring- I’ll make sure that is changed! You can restore from a backup using the server tools (the server has to be stopped). From the server interface (GUI), make sure the server is stopped, and go to tools > options > restore tab. From there you point to the backup you want to restore to. This option is an all or nothing option, it will overwrite the entire database.

    Restoring one item like a deleted BOM is possible, but a little more difficult. It may be easier to just re-create it. If that isn’t an option, you have 2 choices. First, you can stop your server, go to tools > options > database tab, and add a new database connection. Point the new connection to your backup database. Using the new connection, start your server. Now you are running on the backup database and you can find your deleted item, export it, then stop the server and reconnect back to your live database and import the deleted item you just exported. The risk with this method is that a user might connect to the server while it’s running the backup database, and any changes they make would be lost since it’s not the live database. You would have to be careful to keep your users out while you export your deleted item.

    The second method would be to run a second Fishbowl Server and connect it to the backup so that you can export the deleted item. The trick here is that if you run 2 Fishbowl servers on the same machine, you have to differentiate them so as not to overwrite anything. To do this you would need to install another server, and change the install directory to a different folder than your live one. Once installed, you then have to change the port the second server uses to run (again, with server stopped, tools > options > server > server port). The advantage here is that you don’t have to stop your live server and there is little risk that a user would change their client port and log into the secondary server.

  3. Is there a way to do a backup *without* using the Schedule?

    That would be handy for one-offs, like moving servers or when you want to do a backup before scheduled downtime.

Leave a Reply

Your email address will not be published. Required fields are marked *

Sharing Buttons by Linksku