Inventory Database Backup & Restoration




Albin O. Kuhn Library & Gallery - Staff Wiki


Inventory Database Backup & Restoration

  1. Go to Start->All Programs->MySQL->MySQL Administrator
  2. Login with root and the long password
  3. Under Backup will be a project called "Inventory Backup" That should backup all tables in the inventory database at 2 am daily to the D: drive with a file name that has the date/time.
  4. To restore a backup Go to Start->All Programs->MySQL->MySQL Query Browser
  5. Go to File and Click New Script Tab
  6. Click Load
  7. Load the most recent backup from D
  8. The Inventory DB will now look as it did prior to the most recent backup

Albin O. Kuhn Library & Gallery . University of Maryland, Baltimore County . 1000 Hilltop Circle . Baltimore MD 21250
(410) 455-2232. Questions and comments to: Web Services Librarian