CS 470                                                               Spring 2013

                     Lab Exercise 8: Database Backup(restore)
                
A copy of the database tables developed for lab exercise 6 is needed to create a
"portable app". The deliverable for lab 8 evaluation is to be an sqldump of the 
category and item tables developed for lab exercise 6. Given a solution is 
submitted for lab 6 there is not an additional deliverable. As a first step in
the evaluation of lab exercise 6, an attempt will be made to import then access
the database tables. If the import is successful, credit will be given for lab 8.

Commands for MySQL database backup(dump) and restore:

   Backup(aka dump):
   
   An example of using mysqldump to copy a database to a text file on (windows)
   device e:
   1. Change to the directory (folder) with the mysqldump utility(or set a path).
      For example:    
      
         cd e:\xampp\mysql\bin
        
   2. Execute the mysqldump program.
      
      E:\xampp\mysql\bin> mysqldump -u userName -p dbName > e:\userName.sql
   
   Restore(to test your backup):
   3. To verify the exported file may be imported to restore the database, it
      is suggested that you attempt to import the file of sql commands and data
      into a different MySQL database(e.g. "test"). For example

      E:\xampp\mysql\bin> mysql -u userName -p test < e:\userName.sql   
   
Note: to earn credit for this exercise it is only necessary to develop, export,
      and submit the lab 6 database.