Home » Categories » Multiple Categories

Events and Room Reserve Files to Back up

NOTE: It is recommended that you keep regular backups of the system at an offsite location, in addition to the same server.

This article explains what files you need to back up for instances installed on the customers' server. Even though it is based on our Events/Room Reserve system, you can also apply the same method for our Summer Reader application. The difference would be in the names of the default web and database folders (They are both usually called "SR" for the Summer Reader module).

Our applications are MySQL based systems. The default name of the database for the Events/Room Reserve system is "autoemail". You need to make sure a backup is kept of it on a regular basis. We also highly recommend that you back up the web folder of the system; which is usually called "lib".

Keep in mind that these names can be different on your server. You can also have copies of them. So it is very important for you to determine the active files (to back up) used on your live/production site to ensure a recovery, should something go wrong.

Finding the right web folder:

  1. Look in the default web root first (c:\inetpub\wwwroot) for the "evanced" or "lib" folder.
  2. If it is there, create and save a test text file in it with the word test and today's date in it for example, then try to bring it up from the site link using an internet browser like this http://...your system link.../lib/test.txt. If you can see the contents of the file you have created, then you got it right. If not, try the next step, this means that the web root is located elsewhere on the machine and has been changed from its default.
  3. You can find where your files are located by browsing your IIS. See if there is a web site for the calendar. If so, right click it and select properties. It will point you to the location of the web files. If you cannot find a web site for the calendar, it could probably be under the default web site, select the default web site's properties to see where they are stored.

Finding the right database:

  1. Now, to find the right database, start by confirming its name. To do that, look in the "common" folder in the default Evanced system web root and locate the defines.inc file. Open it in Notepad and find the line of code referencing the DSN="....". It is usually "autoemail".
  2. Then go to the database manager (ODBC), under System DSN tab, highlight the autoemail ODBC connection and select configure just to see the configuration
  • Check where the database is. If the server field has been filled by anything else other than "localhost" or blank, then the database is actually on a different server. YOU NEED ACCESS TO THAT OTHER SERVER AS WELL TO GET A COPY OF THE DATABASE.
  1. If the database resides on the same server, then you can locate its location from SERVICES under Control Panel>Administrator Tools. Find MySQL service, right click and select properties. The path will display there.
  • If you have multiple instances/version of MySQL, you need to determine the version being used. At this point, we recommend that you use our support department's help if not sure.
  1. Once you have located the right path of the database, open the "autoemail” folder and make sure that latest modifications in it are current. You should see some dates from today's date or last night.
0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
There are no comments for this article. Be the first to post a comment.
Related Articles
Upgrading MySQL Database from 3 to 5
Viewed 4447 times since Tue, Sep 6, 2011
Displaying events in NoveList Select
Viewed 9564 times since Mon, Feb 20, 2012
How Secure is Our Patron Information?
Viewed 7433 times since Wed, Sep 28, 2011
How to add a logo or website header to my calendar page
Viewed 27428 times since Tue, Sep 27, 2011
Before Transferring Your Evanced Site to Your New Server
Viewed 9339 times since Fri, Apr 20, 2012
E-Notify Status Notification
Viewed 4921 times since Fri, May 11, 2012
Security update for Events/Room Reserve – v7.68.8
Viewed 3110 times since Tue, Sep 22, 2015
Frequently Asked Questions About Migration to SignUp from Events
Viewed 15602 times since Wed, Sep 12, 2012
Differences between SignUp and Events
Viewed 35830 times since Thu, Jan 24, 2013