Backing Up and Restoring the Database
Any database that contains regularly updated information should be regularly backed up. A SAM backup saves a record of the entire database at a given moment. These system backups should ideally be saved onto portable media and stored off-site.
NOTE: It is good practice to use third-party backup software to back up the entire SAM Server hard drive. Using third-party backup software requires stopping the ScholasticMySQL and ScholasticJBoss services for the duration of the backup.
Backing Up
Only a user with administrator permissions may back up the database. Use the backup utility in SAM to schedule when to perform the backup. As it is not possible to successfully back up the program while anyone is using SAM or any Scholastic program, schedule the backup for after-school hours.
To back up the database:
1. Sign in to SAM as an administrator.
2. Click the Roster tab to access the District or School Profile screen. 3. Click the Backup link in the Advanced Settings menu in the lower right
5. Click Back to change the schedule, or click Export to finish the scheduling.
A notification will appear in the Message Center on the SAM Home Page when the backup is finished. Close the window to return to SAM, then access the backup *.zip file by clicking the Show Me link in the Message Center. By default, backups are saved to the following location:
Restoring a Database
Restore a previously saved database using the SAM Database Restore Utility. WARNING: Restoring a database overwrites the current database. This function should only be performed by the School or District Technical Coordinator and only if the current database is lost or corrupted.
Restore the SAM database using the Enterprise Edition Database Restore Utility, which may be downloaded from the Scholastic EE Software Updates sites:
•
Scholastic Technical Support:www.scholastic.com/education/techsupport
•
READ 180®:http://teacher.scholastic.com/products/read180/techsupp/updates.htm
•
Scholastic Reading Counts! ®:http://teacher.scholastic.com/products/readingcounts/techsupport/ patches.htm
•
Scholastic Reading Inventory™:http://www.scholastic.com/techsupport/sri.htm
NOTE: The database backup file must have been generated in SAM Enterprise Edition 1.1 or later, and the backup may only be restored to a server running the same version of SAM. For example a SAM Enterprise Edition 1.1 database cannot be restored to a SAM Enterprise Edition 1.2 installation.
To Restore a Database:
1. With the Database Restore Utility *.zip file extracted, copy the Utility, called “restoreEEDatabase.jar,” to the “util” folder under the SAM Enterprise Edition installation directory (e.g.,
/ScholasticEE/SAM_Server/util).
2. If the backup was created in SAM, extract the *.zip file. In the *.zip file there is a *.sql file. Save this file to a convenient location (the same “util” folder where the Utility is, for instance).
Windows OS
•
Open a Windows command prompt.•
Enter the following command: net stop ScholasticJBoss Macintosh® OS•
Open a Terminal Window and the following command: sudo /sbin/SystemStarter stop ScholasticJBoss5. Run the Database Restore Utility. To run the Utility in Windows®:
•
Open a Windows command prompt.•
Change directories to the SAM Enterprise Edition installation directory (e.g., C:\ScholasticEE\SAM_Server).•
Enter the following command:java\bin\java –jar util\restoreEEDatabase.jar [database file path]
•
NOTE: [database file path] is the full path to the database backup .sql file that is being restored.•
A warning message appears. To continue, type ‘y’ and press enter. To run the Utility in Macintosh OS:•
Open a Terminal Window.•
Change directories to the SAM Enterprise Edition installation directory (e.g., /ScholasticEE/SAM_Server).•
Enter the following command:java –jar util/restoreEEDatabase.jar [database file path]
NOTE: [database file path] is the full path to the database backup .sql file that is being restored.
6. The database is now being restored. This may take several minutes if the file is large. Once the restore is completed, restart the
ScholasticJBoss service. Below are steps for Windows and Macintosh systems.
Windows OS
•
Open a Windows command prompt and enterthe following command: net start ScholasticJBossMacintosh® OS
