To preserve the old applications, you must follow these steps:
<ol>
<li>Back up the database:
<pre>
su - mysql
cd ~www/mysqlarchive
mkdir -p applications/`date +%Y`
cd !$
/usr/local/mysql/bin/mysqldump -u root reu_4 > reu4_4.db
/usr/local/mysql/bin/mysqldump -u root securit_4 > securit_4.db
/usr/local/mysql/bin/mysqldump -u root star_4 > star_4.db
/usr/local/mysql/bin/mysqldump -u root wise_4 > wise_4.db
</pre>
Check the contents of the files.

<li>Go to <a href="http://trust.eecs.berkeley.edu/mysql">mysql</a> for the site
<li>For each database (<code>reu_4</code>, 
<code>securit_4</code>, <code>star_4</code> and <code>wise_4</code>), perform the following operations.  We are doing two things: 1) Moving the previous database from <code>apply</code> to <code>apply<i>year</i></code> where <code><i>year</i></code> is either this year or next year and 2) copying just the structure (not the data and structure) from the newly created database (<code>apply<i>year</i></code>) back to <code>apply</code>.
<ol>
<li>Find the <code>apply</code> table.
<li>Select the <code>Operations</code> tab
<li>In <code>Move table to</code> area, rename the database to <code>apply<i>year</i></code>, for example, <code>apply2015</code>
<li>Then copy just the structure back to a new,
empty table with just structure called <code>apply</code>
</ol>
<li>Then, on the website, disable and reenable the application for each workgroup by doing to 
<a href="http://trust.eecs.berkeley.edu/wise/admin/config">Admin -&gt; Configure Group</a>, unchecking "Application Form", clicking "Change Group Configuration" and then checking
"Application Form" and clicking "Change Group Configuration".
<br>Email will then be sent to the administrator
</ol>


<p>The following php updates must occur:</p>

<ol>
<li>As root or the www user on moog, edit <code>~www/php/include/apply.inc.php</code> and update the year in
<pre>
Standing as of February 1, 201<i>X</i>
</pre>
</li>

<li>As root or the www user on moog, edit <code>~www/php/apply/apply.php</code> and add a menu item for the previous year.
<br/>Look for:
<pre>
    // Each year, add a clause for the previous year.
    if (($selector != "all" || $table != "apply2014") && sqli_exists($db, "apply2014")) {
        $marginCommands .= "&lt;li&gt;&lt;a href="/$group/$originalSubpage/all/2014"&gt;All 2013 ${recordShort}s&lt;/a&gt;&lt;/li&gt;n";
    }
</pre>

Copy the if clause and replace the year in the copy with the current year.

<pre>
    // Each year, add a clause for the previous year.
    if (($selector != "all" || $table != "apply2015") && sqli_exists($db, "apply2015")) {
        $marginCommands .= "&lt;li&gt;&lt;a href="/$group/$originalSubpage/all/2015"&gt;All 2015 ${recordShort}s&lt;/a&gt;&lt;/li&gt;n";
    }                                                       
    if (($selector != "all" || $table != "apply2014") && sqli_exists($db, "apply2014")) {
        $marginCommands .= "&lt;li&gt;&lt;a href="/$group/$originalSubpage/all/2014"&gt;All 2013 ${recordShort}s&lt;/a&gt;&lt;/li&gt;n";
    }
</pre>

<p>This is necessary so that Aimee can look at the old applications.</p>
</li>
</ol>