Restoring Your Database From Backup

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

If you’ve encountered issues with updating your installation to a new release or you’ve encountered some other issues, you can restore your database using one of your recent backups. You can restore your database using phpMyAdmin or by using the command line.

Restore Using phpMyAdmin

  1. Log into phpMyAdmin.
  2. Click Databases and select the database where eduTrac SIS tables are installed.
  3. You should now see a list of tables. Since the installation uses Foreign Keys, you will need to drop all the tables from the database.
  4. Scroll to the bottom of the page, click Check All and select Drop from the dropdown list to the right. Once you do so, you will be redirected to a new page.
  5. You should see message which asks if you are sure you want to execute the drop query. Before choosing yes, unselect the following option: Foreign key check. Now click Yes to execute the drop query.
  6. When the query is finished, at the top if a navigation bar. Click the Import link and you will be redirected to the import page.
  7. Under File to import, click browse and select the latest .*sql file from your backups.
  8. Click the Go Button.

If all went well, then you have restored your database to a point before your update or before what ever issue you were having.

Restore Using Command Line

In order to restore your database from a recent backup, you should upload the *.sql file to your server and then follow the below instructions.

  1. Create an ssh session to your server.
  2. Follow steps 4 – 6 from the section above entitled: Restore Using phpMyAdmin.
  3. Navigate to where you uploaded your *.sql backup file.
  4. Issue the following command: mysql -u root -p etsis < etsis.sql. root is the MySQL user, etsis is the database name, and etsis.sql is the name of the *.sql backup file.
  5. Once you run the above command, you will be asked to enter the password for the MySQL user.

If all went well, then you have restored your database to a point before your update or before what ever issue you were having.

Last Modified: Feb 1, 2016 @ 1:57 PM

Was this article helpful?

Related Articles

You must be logged in to reply to this topic.