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
Room Reserve Installation Instructions
Viewed 9263 times since Tue, Sep 6, 2011
Room Reserve - Reservation Limits
Viewed 4108 times since Wed, Sep 28, 2011
How to Locate Unsecured content in a Secured HTTPS page
Viewed 6190 times since Tue, Dec 20, 2016
Room Reserve- Most Common Credit Card Related Questions
Viewed 345167 times since Wed, Sep 28, 2011
What do the tags available from the system and email templates mean?
Viewed 6722 times since Thu, Oct 27, 2011
Secured access to content via HTTPS FAQ
Viewed 5026 times since Tue, Dec 20, 2016
How To Events-Remove a single date from a recurring series
Viewed 21177 times since Tue, Sep 27, 2011
How do I generate emails for Room Reservation changes
Viewed 4110 times since Thu, Oct 6, 2011
Hosted Customer Sites Security Protocol
Viewed 5247 times since Wed, Sep 28, 2011
Adding Google Analytics to the Event Calendar and Room Request public pages
Viewed 20812 times since Thu, Dec 8, 2011