Web Databases

Sample MySQL Database

[Nov 23, 2009 14:09] Web access to Microsoft Live@edu accounts now works.

The PHP and MySQL example pages and Perl DBI and MySQL example pages all refer to a MySQL database called "mst3k_Inventory". If you would like to use the example PHP scripts on your own web site, you will need to do the following:

  1. Download a copy of the database onto your hard drive. Right-click on the following link and choose “Save link as”. Save the file to your desktop or other easily accessible location:

    Inventory.txt

  2. Get a MySQL account if you don't already have one, and create a database on dbm2.itc.virginia.edu.
  3. Use phpMyAdmin to upload the database contents to the database you created on dbm2. For information on using phpMyAdmin, visit the phpMyAdmin website.

© 2009 by the Rector and Visitors of the University of Virginia.

The information contained on the University of Virginia’s Department of Information Technology and Communication (ITC) website is provided as a public service with the understanding that ITC makes no representations or warranties, either expressed or implied, concerning the accuracy, completeness, reliability or suitability of the information, including warrantees of title, non-infringement of copyright or patent rights of others. These pages are expected to represent the University of Virginia community and the State of Virginia in a professional manner in accordance with the University of Virginia’s Computing Policies.