This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
mysql_databases [2012/02/07 18:55] 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: | Databases can be accessed using: | ||
* The mysql command on the command line in a remote or local shell | * The mysql command on the command line in a remote or local shell | ||
* Via [[https://acm.cs.uic.edu/phpmyadmin|PHPMyAdmin]] | * 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 22: | 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 |