Changes
Jump to navigation
Jump to search
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==