CS340_PCDB

App Screenshot

Link to Project

SQL Tips

After SSH into an OSU flip server, login to the SQL server by executing the following command. Replace <LOGINNAME> with the login username.

mysql -u cs340_<LOGINNAME> -h classmysql.engr.oregonstate.edu -p

To load a sql file, navigate to the SQL source directory

source filename.sql;

To create a back up of the sql db, navigate to the SQL source directory

mysqldump -u cs340_<LOGINNAME> -h classmysql.engr.oregonstate.edu -p s340_<LOGINNAME> > backup_YYYY_MM_DD.sql

References

SQL Standards