This is a short video on how to backup your SimpleRisk database. Below you will find the script to this video.
SIMPLERISK– transforming risk management. simple. Automated. Effective
How to Backup Your SimpleRisk Instance
Periodically backing up your SimpleRisk database is an important best practice.This short video will show you two methods on how to perform database back-ups.
While we perform daily back-ups of the entire instance of SimpleRisk for customers that subscribe to our hosted services, we strongly recommend to all customers, whether on-prem or hosted, to perform back-ups at more frequent intervals. This practice will ensure minimal downtime, if for any reason you should experience an unforeseen system outage.
Method #1 This method uses a built-in function in SimpleRisk to create a “mysqldump”and downloads it to your machine. To do this, we navigate to the “Configure” menu at the top and then the “Register & Upgrade” menu on the left. This will display a page that looks like the sample pictured below.
You will need to have a registered instance of SimpleRisk with the “Upgrade” extra installed, in order for the “Backup the Database” button to appear. Just to be clear, this information will never be sold to a third-party and will solely be used to support you with your use of SimpleRisk.
Next we need to enter the registration information and select “Update.” If this doesn’t execute properly, you will need to check and make sure that your “simplerisk” directory is writeable by the web user.
When “Backup the Database” button is displayed near the center on the right hand side of the page, all you’re required to do is to click the adjacent button. This will download a SQL file containing your SimpleRisk database. Once the download of the database is finished, this process is complete.
Method #2 The second method for backing up your database is to perform a manual “mysqldump.” This can be done from terminal using the following command: “mysqldump -u root-p dbname > simplerisk.sql” (DB name if default is “simplerisk”). This should will create a file in your current directory called “simplerisk.sql” and is a backup of the database in its entirety.
This concludes the video on “How to Perform a Backup” in SimpleRisk. If any questions were left unanswered or could use more in-depth descriptions, please use our Customer Support email address which is firstname.lastname@example.org