DV Unit CMS:Insallation Guide

Software
Download and Install


 * XAMPP
 * Tortoise

Using XAMPP

 * XAMPP is free software and contains an Apache distribution with MySQL, PHP and Perl
 * When using the dv-unit application XAMPP needs to be running Apache and MySQL
 * More info on XAMPP http://foss.unh.edu/opencomputing/index.php/XAMPP

Using Tortoise

 * Go to the XAMPP directory and open the htdocs folder
 * Create a folder to put the dv-unit data in
 * Right click on the folder and click "SVN Checkout"
 * The URL of repository is the only part you will need to add

Current repository http://dv-unit.googlecode.com/svn/trunk/
 * Click OK to begin downloading files

Local Machine

 * Open Command Prompt
 * Navigate to MySQL in XAMPP

cd ..\..\xampp\mysql\bin


 * Run MySQL as root by running the following cmd in the MySQL directory

C:\xampp\mysql\bin>mysql -u root -p


 * Run the Scripts from their directories

mysql> source C:\xampp\htdocs\..\sqlcode\


 * Database - dv-unit_create_db_and_user.sql
 * Tables - dv-unit_create_tables.sql
 * Data - dv_unit_insert_data.sql

Server

 * Same as a local Machine install with one exception. When first running MySQL you will put in the host name, user name, and password

C:\xampp\mysql\bin>mysql -h  -u  -p


 * The version of MySQL used for these direction works best if you leave the password blank and let it ask you for the password after you hit enter.

Confirm the Install

 * Use the following commands to give a print out of the scripts if they were installed correctly.

mysql> show databases; show tables;