RASS Server Instructions:
1. Download the update from the update page that matches your table revision.
2. Replace tlmmysql.mde in C:\LMBS\TheLeanMachine
3. Open TLM Enterprise from the server so that the file above is being opened.
4. Relink to the tables of your MySQL database. Enter the database name and localhost for the IP Address. Updates will usually be pre-linked to a database name of “primary,” so if your MySQL database is names primary, no re-linking will be required for RASS installations, as the default servername/IP is always “localhost.”
5. Once linked, replace tlmmysql.mde in all the user folders with a copy of the one just relinked.
Windows Server 2008: users\username\AppData\Local\tlmmysql.mde
Windows Server 2003: \Documents and Settings\username\Local Settings\Application Data\tlmmysql.mde
TLM Enterprise is being improved from a performance standpoint to work outside of the RASS environment, however, this is a work in progress whether this is a viable option for you depends on your specific network/server/database circumstances.
1. On the users computer, run the update.exe file from the update page that matches your table revision. (Download and run the Complete Support File Package if this is a new installation for this user’s computer.)
2. Open TLM and relink to you MySQL database using the internal IP Address of your server, and your MySQL database name. Relinking will always be needed, as the name of your MySQL servername/IP address on your network will likely be different than how the update is configured.
3. Make sure the MySQL My.ini file on the server has the following code so that MySQL will respond to requests from the network.
Edit My.ini file as follows: (C:\Program Files\MySQL\MySQL Server 5.x)
# The TCP/IP Port the MySQL Server will listen on
max_allowed_packet = 1048576000;
UPDATING TLM TABLE REVISION USING NAVICAT
1 . BACK UP YOUR MySQL DATABASE!
2 . Make sure MySQL has a Master database.
3. move Master.psc from the Update.ZIP into the backup folder of the Master database and restore it.
4. Perform a Structure Synchronization between your database and the master database to pick up the table and field changes.
****BE VERY CAREFULL, do not select a DATA Synchronization by mistake. (Restore your back up if you do) ****