To install mSQL, connect to your Virtual Server via
Telnet or SSH and
do the following, according to your Virtual Server O/S:
FreeBSD & Solaris mSQL 2.0.11
Use vinstall to install mSQL:
% vinstall msql
Run the MySQL installation program:
If you don't know the Virtual Server O/S, try the following:
These mSQL installation programs copy the mSQL software onto your Virtual Server.
This includes an msql.acl file with some "intelligent" defaults.
The installation programs determine if you have mSQL v1 installed.
If you do have mSQL v1 installed, the
installation programs attempt to convert your
existing database files to v2 database format.
Your v2 databases are stored in the following directory, depending on
your Virtual Server O/S:
The installation programs do not destroy your v1 database
The installation programs also start the mSQL daemon.
To restart the mSQL daemon use the following command:
If you are upgrading from v1, you will eventually want to remove the
mSQL v1 directory ~/msqldb manually when you are certain the
upgrade worked. You can do this by typing the following at a command
% rm -rf ~/msqldb
Make sure your databases are working correctly before doing this!
% daemon -f /usr/local/bin/msql2d
Notice that a similar command has been added to your
Rc file (~/etc/rc) 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
% ps auxww | grep msql
The msql Client
mSQL v2 uses different command-line commands than
v1 of mSQL. The following table summarizes the
The installation programs create some aliases 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.
Site Map | Contact Us!
Copyright © 1998-2001 Bright Builders, Inc. All rights reserved.
Last Modified: Fri Mar 2 22:21:36 2001 GMT
Page Built: Mon Jul 2 19:55:44 2001 GMT