User Tools

Site Tools


mysql_databases

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mysql_databases [2011/03/22 17:15]
127.0.0.1 external edit
mysql_databases [2021/05/02 21:36] (current)
Line 1: Line 1:
 +====== MySQL Databases ======
 +
 ====== Systems ====== ====== Systems ======
 Databases can be created on: Databases can be created on:
   * The ACM server, acm.cs.uic.edu   * The ACM server, acm.cs.uic.edu
-  * Sorbis, linux.cs.uic.edu+  * The ACM workstations via the script <​code>​cs480</​code>​ 
 + 
 + 
 +Databases can be accessed using: 
 +  * The mysql command on the command line in a remote or local shell 
 +  * Via [[https://​acm.cs.uic.edu/​phpmyadmin|PHPMyAdmin]] 
 + 
 +====== Local Workstations Databases ====== 
 + 
 +A local database can be created on our workstations using a script call "​cs480"​ 
 + 
 +This script will setup and run a database stored in your home directory under your account 
 + 
 +When run it will start your mysql server as well as an HTTP server on localhost:​8080 with a PHPMyAdmin instance 
 + 
 +**Usage:​** 
 +<code > 
 +cs480 - Prints help test 
 +cs480 setup - Creates needed files 
 +cs480 start - Starts servers 
 +cs480 stop - Stop server 
 +</​code>​
  
 ====== Creating a database ====== ====== Creating a database ======
Line 20: Line 43:
 mysql users are **not** at all related to system users. mysql users are **not** at all related to system users.
  
-====== ​backups ​======+====== ​Backups ​======
  
 backups on acmdb are kept in /backup backups on acmdb are kept in /backup
mysql_databases.1300814113.txt.gz · Last modified: 2021/05/02 21:36 (external edit)