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
How to add a logo or website header to my calendar page
Viewed 29693 times since Tue, Sep 27, 2011
Room Reserve - Credit Card Processing
Viewed 3552 times since Wed, Sep 28, 2011
Deleting a single session in a recurring event
Viewed 8698 times since Thu, Oct 27, 2011
Product Implementation Checklist
Viewed 7888 times since Mon, Oct 10, 2011
Scheduling Holiday Closings in Events and Room Reserve
Viewed 12514 times since Tue, Feb 14, 2012
Evanced Application Hosting FAQ
Viewed 7220 times since Mon, Jun 8, 2015
Everything You Need to Configure Email in Events and Room Reserve
Viewed 13174 times since Tue, Apr 3, 2012
Upgrading MySQL from 3 to 5
Viewed 9959 times since Wed, Sep 28, 2011
Is there Evanced Calendar for Mobile Access?
Viewed 8200 times since Thu, Oct 6, 2011