Using the Server Utility
The server utility is a small program that enables you to do certain things with the database server without having to start MemberTies at all. It enables you to restart the server if necessary, delete a database, package a database for easy transport, and perform various other maintenance functions.
The server utility has a separate executable file located in the MemberTies program directory called "mtsrv.exe". (There should also be an icon for it in the Start Menu along with the MemberTies icon.)
Note: The server utility window is a way to look at the server that is running in the background. It is not the server itself. You can open and close the utility without affecting whether the server is running or not. The only way to manually shutdown the server is to click "Stop Server". Closing the window will have no effect.
When you launch the utility, it will immediately display the current status of the server.
The server utility includes several sections containing various options.
The options in this section control the starting/stopping of the server itself:
Start - Reads configuration files and starts/restarts the server. If a Windows service has been installed to control the service, this will start/restart the service.
Stop - Stops (shuts down) the running server and aborts all existing connections. You should be certain nobody is logged in before doing this. If a Windows service has been installed to control the service, this will stop the service.
Refresh - Redisplays the server status with the current uptime values.
The options in this section allow you to perform various tasks:
Start MemberTies - Starts the main program. This button is here for convenience only. It has the same effect as starting the software using the normal desktop or Start menu icon.
Maintain Tables - Opens the table maintenance window. You will be prompted for a login username and password, and will have to choose a database to maintain when selecting this option. Once logged in, see Maintaining Tables for more information.
Remove Database - Enables you to delete a database. You will be prompted for a login username and password, and will have to choose a database to delete when selecting this option. See Deleting a Database for more information.
Sys Info File - Generates a text file that can be sent upon request to MemberTies to help troubleshoot a problem. The text file is saved to a location you specify, and contains information from various MemberTies configuration files.
Local Server Settings
The options in this section control the way the server starts and runs. Ordinarily you should never need to change any settings here. If you choose to make changes, be very careful and take note of what the current settings are. An incorrect setting will prevent the server from starting and MemberTies will be unable to access any databases.
Never include a trailing backslash ( \ ) on any directory entry!
Root Database Directory - The parent directory containing all of your database sub-directories. This defaults to "c:\programdata\MemberTies\database".
Root Server Directory - The parent directory containing the server files. This defaults to "c:\program files\MemberTies\server".
Temp Files Directory - The directory where the server should write temporary files. You must have read/write permissions to this directory or the server will not be able to start. This defaults to "c:\programdata\MemberTies\temp".
Server IP Address - The address to which the server is bound. This defaults to "localhost."
Server Engine - The name of the MySQL server engine in use. This defaults to mtmysqld.exe.
Server Port - The port on which the server is listening for connections. This defaults to 3310.
Windows Service Name - (optional, but recommended) The name of the service that controls the server. There is no default for this because it is optional. See Running the Server as a Windows Service for details.