Part D

1. Deliverables for Parts A, B, & C must be printed as a report with a cover sheet attached.  See Administrative Details on page 13 for more details.  Your report must include headers and footers that include your name, student number, unit name, assignment name, and page numbers.  Your report must be checked for spelling and grammar.  Your report must also be formatted so that it is well set out and easy to read.  

a) A soft copy of your assignment documentation report must be zipped and uploaded to Moodle.  

b) The SQL that can be used to restore your database should also be uploaded to Moodle.  You can create the SQL for your database as follows:

Use the mysqldump command to create a text version of the database.  Use mysqldump to create SQL file that contains a list of SQL statements which can be used to restore/recreate the original database.

The syntax is as follows:

$ mysqldump -u [uname] -p[pass] [dbname] > [backupfile.sql]

WHERE:

[uname] Your database username

[pass] The password for your database

[dbname] The name of your database

[backupfile.sql] The filename for your database backup

You do not need to log on to MySQL.  For example from the DOS command prompt, the syntax is:

e:\xampp\mysql\bin>mysqldump -u root MyDB > e:\MyDB_bak.sql

This will create the SQL file that can be used to restore your database.

OR ---

You can save your script as you go to notepad.