Installing mSQL
	What's New in IT IT Consulting Phones/VoIP Internet Security About Us Home

	Web Site Hosting	Web Design	Broadband/Access	E-Mail Solutions	Accept Credit Cards	Hosting Support

To install mSQL, connect to your Virtual Private Server via Telnet or SSH and do the following, according to your server O/S:

• FreeBSD [mSQL 2.0.11]
  Use vinstall to install mSQL:

  % vinstall msql

• Solaris
  mSQL is not available. Try MySQL or PostgreSQL.

• If you don't know the Virtual Private Server O/S, try the following:

  • Which O/S Is Your Virtual Private Server Running?
    

These mSQL installation programs copy the mSQL software onto your server. This includes an msql.acl file with some Virtual Private Server friendly 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.

The installation programs do not destroy your v1 database directory (~/msqldb).

NOTE: 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 prompt: % rm -rf ~/msqldb Make sure your databases are working correctly before doing this!

Your v2 databases are stored in the following directory:

• FreeBSD
  ~/usr/local/Hughes/msqldb

The installation programs also start the mSQL daemon. To restart the mSQL daemon use the following command:

% 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 server. To check on the status of the mSQL daemon, do the following:

% ps auxww | grep msql

The msql Client
mSQL v2 uses different command-line commands than v1 of mSQL. The following table summarizes the differences:

mSQL v1	mSQL v2
msql	msql2
msqladmin	msql2admin
msqldump	msql2dump
relshow	relshow2

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.

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!

Copyright © 1996-2024, Integrated Technical Solutions, Inc., all rights reserved. See Terms/Legal for trademarks, copyright, and terms of use.