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/09/11 21:17]
walter [Systems]
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
 +  * 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 19: 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.1315775854.txt.gz ยท Last modified: 2021/05/02 21:36 (external edit)