Topics:
MySQL SCO Unix installation (Never again. Forget about it).
MySQL server startup/shutdown
Move data files from/to MySQL
Change MySQL's data directory location.
Databases are named as module#company# just like our subdirectories under dsk0.
Example: A/R is module 210 so the A/R database name for company 1 is 210001.
To see a list of all databases in MySQL enter this command at a MySQL prompt.
mysql> SHOW DATABASES;
Before you can acces a table within a database you must issue a "USE databasename" statement like:
mysql> USE 210001;
After giving the USE statement you can see a list of all tables within that database with this command.
mysql> SHOW TABLES;
The databases are physically stored in /u/mvs/mysql
Only the MVS machine stores them in /u1/mvs/mysql
RUN requires a .ini file to interface with MySQL: $MVS_ROOT/dsk0/001004/mysql.ini