Your eduTrac SIS database contains all the information with regards to courses, academic programs, grades, staff and a plethora of student information. Because of this, it is important that you keep constant backups of your installation.
It is also recommended that you keep backups or push backups to several places and not just keep them on your server. If you are interested in pushing backups to an external cloud service, we highly recommend using Amazon S3. Using third party cloud services goes beyond the intended purpose of this article, but there is a script on Github that you can implement in order to push backups to Amazon S3.
If you read through the documents on this site, you might have come across the Cronjob Handler article. In this article it gives you detailed instructions on using cron handlers as well as setting up a master cronjob. Database backup is within the list of cron handlers you can use.
Below are several articles that will help you with regards to backing up as well as restoring your eduTrac SIS installation.
Backing Up Your Installation
Backing up your eduTrac SIS installation consists of two parts: the database and the files. The following instructions will show you how to backup both the database and the files.
There are several different ways in which you can backup your files if you choose not to use an automatic process.
If you are using a hosting environment with a control panel, most control panels have a file manager with the option to zip files. If this option is available to you, you can use this to select all of the eduTrac SIS files and use the zip option to create a zip file.
If you don’t have a file manager, using FTP is another alternative. Create a folder on your computer where it is easily accessible (i.e. Desktop). Then log into your server using an FTP client. Once you are logged into your server, select all the eduTrac SIS files and download them to the folder you created on your computer.
If you are comfortable with using command line and have the option, you can create a shell session to your server to zip your files. Once you’ve created a shell session, navigate to the root of your installation. Once you are at the root of the directory where your files are stored, you will need to use the following structure:
[zip command] [zip file name] [files/directories to zip]
Following the structure above, our zip command should be similar to what’s below:
zip -r archive.zip *
The asterisk at the end is a wildcard which includes everything in the current directory. Once you have a backup copy of your files, you need to move them to a secure location so that no one can download the zip file with your database credentials.
etSIS DB Command Line
You can also use the command line feature of eduTrac SIS for creating a backup of your database.