| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST1602/Labs/Lab04/ |
Upload File : |
<?
// JimMartinson/CST1602/Labs/Lab03/index.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
require('application.phpinc');
require('Gradebook/EvaluationSubmission_BEGIN.phpinc'); // Replaced.
$disabled = '';
#$disabled = ' disabled'; // Comment this line to enable lab.
?>
<style type="text/css">b {white-space:nowrap;}</style>
<fieldset><legend>Description</legend>
The purpose of this lab is to demonstrate your ability to backup a database.
<?=$gradeNote?>
<? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><? } ?>
</fieldset>
<fieldset><legend><?=$evaluationType?> <?=$evaluationNumber?> Assignment</legend>
<ol class="count">
<!-- 1 -->
<li>
Create a directory called <b><?=$evaluationName?></b> inside of your <b><?=$courseNumber?>\Labs</b> folder. We will use it for all work performed in this lab.
</li>
<!-- 2 -->
<li>
Create a user that can backup the classicmodels database:
<ol>
<li>Create the user <b class="copyText">classicmodels_backup</b>@localhost with a password of <b class="copyText">classicmodels_backup</b>.</li>
<li>Grant the user the privileges needed to backup the classicmodels database.</li>
<li>Show that you have done this correctly:
<ol>
<li>Run the query <span class="code copyText">SHOW GRANTS for classicmodels_backup@localhost;</span> and expand the Result Grid to the right so the entire result is visible.</li>
<li>Take a screenshot of the MySQL Workbench window showing query results and save it as <b class="copyText"><?=$saveFilename?>.png</b> in your <b><?=$evaluationName?></b> folder.
<span class="note">Ensure the grants are fully visible in your screenshot.</span>
<? showBegin('See example screenshot','Hide example screenshot'); ?><br>
<img src="images/grants.png" width="" height="" alt="Backup user privileges example screenshot"/><br>
<? showEnd (); ?>
</li>
</ol>
</li>
</ol>
</li>
<!-- 3 -->
<li>Backup the classicmodels database using the classicmodels_backup user:
<ol>
<li>Write a cmd script that will (This is a command script for Mac or sh script for Linux):
<ol>
<li>Run mysqldump.</li>
<li>Backup the <b>classicmodels</b> database.</li>
<li>Using the <b>classicmodels_backup</b> user.</li>
<li>Include the password on the command line.</li>
<li>Output the result to a <b><?=$saveFilename?>.sql</b> file.</li>
<li>Save the script as <b class="copyText"><?=$saveFilename?>.cmd</b> (Windows), <b class="copyText"><?=$saveFilename?>.command</b> (Mac), or <b class="copyText"><?=$saveFilename?>.sh</b> (Linux) in your <b><?=$evaluationName?></b> folder.
<br><span class="note">You need the set the file as executable on Mac or Linux.</span>
</li>
</ol>
</li>
<li>Run <?=$saveFilename?>.cmd from the <b><?=$evaluationName?></b> folder.</li>
</ol>
</li>
<!-- 4 -->
<!-- 5 -->
<!-- 6 -->
<!-- 7 -->
<li>Turn in your assignment:
<ol type="a">
<li>Make sure the following files are in your <b><?=$evaluationName?></b> folder.<?
$filesToSubmit = array(
$saveFilename.'.png',
$saveFilename.'.cmd (windows), '.$saveFilename.'.command (Mac), or '.$saveFilename.'.bash (Linux)',
$saveFilename.'.sql',
);
showFileList($filesToSubmit);
?>
</li>
<li>Zip up your <b><?=$evaluationName?></b> folder into a file named <b><?=$uploadFilename?></b>.</li>
<li>Then attach this file to the assignment in D2L for grading.</li>
</ol>
</li>
</ol><? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><br><? } ?>
</fieldset>
<?
require('Gradebook/EvaluationSubmission_END.phpinc'); // Replaced.
#require('../../ReferencesResources.phpinc');
#require('JimMartinson/ContactInformation.phpinc');
require('common/pageFooter.phpinc');
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>