Changes

Jump to navigation Jump to search
811 bytes added ,  16:28, 8 December 2011
no edit summary
*This page is protected so that only Ed, RaniUsha, Toby and Misiek can read or edit it.
I will be posting reports and other materials on the OK Cupid project here.
 
==Setup Instructions for Usha==
 
#Go to vpn.hbs.edu and click Network Connect -> Start
#Using SSH client, connect to researchgrid.hbs.edu
#Connect the MYSql cluster: msyql -h rcsmysql.hbs.edu -u eegan -p --ssl-ca=rcsmysql
 
Useful commands:
 
mysql> SHOW Databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mpiskorski_tstuart |
| okcupid |
| okcupid_2 |
+--------------------+
4 rows in set (0.02 sec)
 
You'll have access to mpiskorski_tstuart
 
USE mpiskorski_tstuart;
 
(Misiek and Toby's working database)
 
SHOW TABLES;
 
There are two datasets: OKC1 and OKC2. We are now working with OKC2.
 
Both datasets have:
Users
Messages
Views
 
OKC2 also has ProfileDelta (changes to profiles).
Describe tables with:
 
DESC TableName
==Data Description from Misiek==
Anonymous user

Navigation menu