MySQL Databases on www - migration to omega planning page - version 1

This is the original planning page.  The current page has the remaining www databases only.  (as of 2011-11-10)

Legend:
no need to migrate: part of infrastructure or can let die here for another reason
already DELETED
part of Intranet: ask Mary Ann about
ALREADY MIGRATED - should be renamed "obsolete_*" on www
will need to migrate: coordination with contact(s) required
ask Ron about
ask Gerry about
action required (probably by Map)


Database Name
Description/Tables
Create Date
Last Update
Contacts
Code Location/URL
00_DbaseInfo database documentation (transferred to here)
- database, contact, email, phone, url, notes
- similar database has been set up on omega; need Gerry to help fill in Drupal info.
2007-09-25
2008-08-07
Ron
n/a

accounts see Intranet documentation 2007-08-16
2010-06-21
Map

AstroClub bulletin board using
simple machines forum software
- confirmed with Sen Mei (astroclub prez), okay to delete; DELETED
2005-03-22
2010-07-06
~astroclub/contactus.html
- sent message to Sen Mei, President
http://www.phas.ubc.ca/AstroClub/
- Forum link at: http://www.physics.ubc.ca/~astroclub/
- Latest Post: "Re: 4" (114/900mm) Refle..." (March 16, 2007, 11:27:57 PM)

atlasdb Atlas group website


cgay
virtual host: atlas.phas.ubc.ca
atlastrt Atlas group - test database; DELETED


cgay

bbampel AMPEL Instrument Bookings - moved to delta
- renamed to bbampel_obsolete
Jul 29, 2010; 
- DELETED Nov. 10, 2011
2006-09-21
2009-11-05
Lukas Chrostowski
(lukasc@ece.ubc.ca)

bbnanofab AMPEL Instrument Bookings
- copy of original but never used
- renamed to bbnanofab_obsolete
Jul 29, 2010;
-
DELETED Nov. 10, 2011
2009-03-13
2009-03-13
Lukas Chrostowski
(lukasc@ece.ubc.ca)

bbshop Bumble Bee trial for shops; not used;  DELETED
2010-01-21
2010-02-17
mokeane

Biophysics Drupal web site
 
2008-11-09
2010-07-04
ubcbiophys@gmail.com
mvanins@gmail.com (Prez)
http://www.phas.ubc.ca/~biophys/
BPS see Intranet documentation 2006-05-16
2010-07-05
Map
c21 high school Physics teachers website;  moved to omega
- saved back-up copy and DELETED
2010-02-09
2010-05-13
theresa

CoopCal special coop WebCal dbase
2011-11-10: renamed to CoopCal_defunct
2007-01-10
2010-06-08
schan
- may move to Exchange?
- check before migrating
db_esessions see Intranet documentation 2004-08-12
2010-07-06
Map
DeptBB phpBB - Discussion Forums - secure site
2010-07-08:- removed from menu; don't migrate
2011-11-10: renamed to DeptBB_defunct
2007-01-10
2009-09-13

Map
https://www.phas.ubc.ca/
  phpBB/login.php?login
- used back in 2007 during retreat and by grads up to last year when they moved to Facebook?
directory see Intranet documentation ?
2010-07-06
Map
dotproject sysadmin project management tool - moved to omega; DELETED


Ron

engphysWWW EngPhys web site?
Developer: Clive Goodinson, clive@goodinson.com 778-885-8542
- archived to /www/engphys/engphysWWW.sql; DELETED
2008-08-06
2010-07-03
jnakane
www.engphys.ubc.ca - no connection to database
- new site being developed on APSC server
fizzBB no tables- DELETED




fizzexams EngPhys forums and exams; examdb_*; forum*
- confirmed that okay to delete - DELETED

2006-10-03
2006-09-22

2009-03-25
2009-03-25
EngPhys Society
compadmin@ubcfizz.com

http://www.phas.ubc.ca/~fizz/
redirects to:
http://www.ubcfizz.com/Home
gallery2 image gallery application (see: http://gallery.menalto.com);
- used by machine shop (https://www.phas.ubc.ca/services/mshop.php)
- made html version in /services/mshop_gallery
- database DELETED
2008-02-27

mokeane; Ron
http://www.phas.ubc.ca/gallery01/main.php
- files in: /g2data/gallery01/albums/mshop
- www:/g2data tarred and zipped as
/g2data.tar.gz
- saved database
in: /home/mshop/public_html/
as: gallery2.sql.obsolete

gb6cat GB6 Radio Variability Catalog - moved to pulsar - DELETED
2005-01-13
2006-03-28
gregory, Ron
http://pulsar.phas.ubc.ca/
gradstudents see Intranet documentation

Map
hardware hardware database - not used; DELETED


Ron

jess Jess Brewers private dbase - DELETED
2003-06-17
2006-03-28
jess

limesurvey moved to omega; DELETED


Ron

liquid_nitro liquid nitrogen usage - never used - DELETED


Map

mirg drupal web site for Medical Imaging Research Group
 - person who set this up may no longer be available
2007-11-26
2010-04-23
aceller
Thomas Humphries (thomash@sfu.ca)
mirg -> /home/mirg/drupal-5.3/
http://www.phas.ubc.ca/mirg/
mri mriresearch site - image gallery and forum
- tables: g2_X; phpbb_X (not used?)



mackay
dave@redesignlab.com
http://mriresearch.ubc.ca/gallery/
http://mriresearch.ubc.ca/forum/ (no link)
mysql main MySQL dbase
- I have been deleting accounts that correspond to obsolete databases, but they have already been propagated to omega,
- need to delete them on omega too


n/a

nanofabWWW AMPEL Nanofabrication Facility Drupal website
- migrate delta:bbnanofab at the same time
2008-08-07 today
Lukas Chrostowski
(lukasc@ece.ubc.ca)
Lena Patsa, webdev, 778-838-4510
http://www.nanofab.ubc.ca/ (virtual on www)
- /home/nanofabw/html/
network see Intranet documentation

Map
otrs PHAS trouble ticket system


Ron
http://www.phas.ubc.ca/otrs/index.pl
outreach mostly moved to omega
- save newsletter sign up data on omega:communications.newsletter


theresa
http://www.phas.ubc.ca/communications/newsletter.php
phpmyadmin This dbase is used by phpMyAdmin.  However it doesn't need to be transfered to omega since it will be created on that machine if it is needed.
-Ron
2003-06-12

Ron

physsocwiki Physsoc wiki; confirmed okay to delete - DELETED
2008-02-27

physsoc@phas.ubc.ca

PRS old clicker database - confirmed with shaun - DELETED
2008-03-27
2008-03-28
shaun
old virtual host: prs.phas.ubc.ca
pykota printer accounting dbase; moved to delta


Ron, Map

Retreat PHAS retreat sign-up (expire 2007-12-31??)
DELETED
2007-09-06
2008-02-28
Map
https://www.phas.ubc.ca/Notices/Retreat/
scuba2inv old scuba2 parts inventory database;
- moved to omega and phpMyAdmin read access given to 'scuba2' user
- DELETED
2004
2009-07-17
halpern
tfelton
- don't need to migrate code to omega
- archived database with code in /home/scuba2/public_html/
old_scuba2inv_db.tar.gz

shared_docs see Intranet documentation

Map

shops see Intranet documentation

Map
sis see Intranet documentation

Map
SMS see Intranet documentation

Map
software available software dbase - totally out of date? DELETED


Ron
no longer point to it from our public web site
stores see Intranet documentation


Map
surveys another one of Jess's many databases DELETED


jess

sysadmin see Intranet documentation

Map
t3_mrigroup typo3 dbase for mri group; not used
- DELETED


2007-08-10
mackay
rauscher (Alex R.)

tas see Intranet documentation
 
Map
tapd TA Professional Development MediaWiki
2011-07-26
2011-07-26
Jonathan Massey-Allard <jmassall@phas.ubc.ca> www.phas.ubc.ca/~phas_ta/w
This is prob. temporary
test default MySQL test dbase

n/a

theorywiki theory mediawiki dbase; obsolete? -DELETED

2006-08-26
rozali

timesheets see Intranet documentation

Map
ts test bed for timesheets


Map

tycho PhasLabs - OnLine lab manuals web application (CAKE)


Map, kotlicki
Phillip Mah (phillipmah@gmail.com)
https://www.phas.ubc.ca/phaslabs/
wc Jess confirmed: DELETED


jess

WebCal100 current WebCalendar database;  see Intranet documentation


Ron, Map
https://www.phas.ubc.ca/WebCalendar/
webcal_backup name says it all - DELETED
2008-09-16

Map

wnppc08 one empty table, "registration"; DELETED
2007-10-09
2007-10-09
cgay

wp_engphys Engphys wordpress dbase; not used; DELETED
2007-09-20
2008-06-22
jnakane

wp_engphyspl Engphys Project Lab WordPress dbase
2009-04
2010-07
jnakane
http://www.engphys.ubc.ca/projectlab/
wp_phys253 not used; DELETED
2007-09-20
2007-09-21
jnakane

xcart shopping cart application used by Shaun Woodruff as an inventory system for the demo room


shaun
http://www.phas.ubc.ca/~shaun/xcart