From ADAM - Academic Data Management for Schools

1. In MySQL, ensure that the database that will be restored to contains no tables. You may wish to rename the existing database and create a new database in order to preserve the original database and not overwrite it with the backup.
2. Unzip the backup file.
3. From the command line, issue the following command,
   • mysql -u [username] -p -D [database] --default-character-set=utf8 < [backup filename].sql
4. In MySQL, remove any tables that begin with view_. This can be done by running the following SQL command from within PHPMyAdmin:
   • DROP TABLE `view_admissions_smslist`, `view_classes`, `view_family_admissions`, `view_family_current`, `view_family_eldest`, `view_family_mailinglist`, `view_family_smslist`, `view_grades`, `view_moodle_courses`, `view_moodle_enrolments`, `view_periods_current`, `view_pupils_current`, `view_pupils_future`, `view_pupils_past`, `view_pupil_class_registrations`, `view_pupil_smslist`, `view_staff_all`, `view_staff_current`, `view_subjects_all`, `view_subjects_current`;
5. Log in to ADAM as an administrative user.
   • On logging in, a single error will be generated because the database views have not yet been created. This error can be ignored.