Albin O. Kuhn Library & Gallery - Staff Wiki

Inventory Database Backup & Restoration

Owned by Former user (Deleted)
Last updated: Sept 25, 2009Version comment
1 min read

  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