Installing mSQL
If you were using a previous version of mSQL (v1.0.x),
you will want to pay careful attention to the instructions below
as they explain the additional steps needed to upgrade to mSQL v2.0.x.
- Connect to your Virtual Server using
Telnet and
run the mSQL v2.0.x installation script by typing:
% installmsql2
The mSQL v2.0.x installation script will perform the following
tasks:
- Copy the mSQL v2.0.x files to the ~/usr/local/msql2
directory on your Virtual Server.
- Determine if you have msql v1.0.x installed.
If you do have msql v1.0.x installed, the mSQL
v1.0.x installation script will attempt to convert your
existing database files to v2.0.x database format.
Note: the script will not destroy your v1.0.x database
directory, "~/msqldb".
- Create an msql.acl file with some "intelligent" defaults.
|
- mSQL v2.0.x uses different command-line commands than
v1.0.x of mSQL. The following table summarizes the
differences:
| mSQL v1.0.x |
mSQL v2.0.x |
|---|
| msql |
msql2 |
| msqladmin |
msql2admin |
| msqldump |
msql2dump |
| relshow |
relshow2 |
Some "aliases" will also be created in your ~/.cshrc file to help
you remember. You will need to do the following at the command
prompt before these aliases take affect:
% source ~/.cshrc
You only need to do this the first time. When you log in again
the changes will be in effect.
- Your v2.0.x databases are stored in your
~/usr/local/msql2/msqldb directory.
You will eventually want to remove the mSQL v1.0.x directory ~/msqldb
manually when you are certain the upgrade worked. You can do this by
typing the following at a command prompt:
% rm -rf ~/msqldb
Make sure your databases are working correctly before doing this.
- Customers upgrading from v1.0.x will need to also upgrade their
mSQL client interfaces. You will note that we have replaced all the
client interfaces in the /usr/local/contrib directory with mSQL
v2.0.x equivalents. These files include the w3-msql.tar,
php-2.0-msql_logging.tar, and perl5.004.tar files. You will
notice that the mSQL v1.0.x tar files are still available in the
/usr/local/contrib/msql1. Please note that the only Perl5 tar
file archive that includes support for mSQL v2.0.x is the
perl5.004.tar tar archive.
- To start the mSQL daemon use the following command:
% daemon -f /usr/local/bin/msql2d
Notice that a similar command has been added to your
~/etc/rc file
to ensure that mSQL restarts in case of a host machine reboot.
mSQL runs as a daemon on your Virtual Server. To check on
the status of the mSQL daemon, do the following:
% ps auxww | grep msql
|
