Overview

This section explains how to backup and restore the database file when using the SQLite database engine.

Backing Up the Database

SQLite stores all database information for the Men & Mice Suite in a single file named mmsuite.db. On Windows this file can be found at C:\Program Files\Men and Mice\Central\ or at C:\ProgramData\Men and Mice\Central\ On Unix based systems, the database file can be found at /var/mmsuite/central


When Men & Mice Central is running, the database file is open so copying the file directly can result in a corrupt backup of the file. The best way to back up the database file is to use the Command Line Interface (CLI). The CLI contains a backup command that allows backing up a running database.

To backup the database using the CLI you need to execute these commands within the command line shell:

login server administrator <password> backup /some/path exit

For more information on the backup command, refer toThe M&M CLI (mmcmd).

 

You can use a scheduled script to backup the database automatically. The Scheduled Scripts section in this user manual contains an example on how to backup the database using a script.

Restoring the Database

To restore the database, you must first stop Men & Mice Central and then replace the database file. The process for restoring the database differs a little depending on the OS running Men & Mice Central.

Windows

To restore the SQLite database file on Windows, do the following:

  1. Install Men & Mice Central, if necessary.
  2. Stop the Men & Mice Central service.
  3. Restore the mmsuite.db data file by copying it to the correct location. The default location for the data file is either C:\Program Files\Men and Mice\Central\ or C:\ProgramData\Men and Mice\Central\. If an older mmsuite.db file is already present, you might want to rename it before restoring.
  4. Start the Men & Mice Central service.

Linux and Solaris

To restore the SQLite database file on Linux and Solaris:

  1. Install Men & Mice Central, if necessary.
  2. Stop Men & Mice Central by issuing the following command:

    sudo /etc/init.d/mmcentral stop
  3. Restore the mmsuite.db data file by copying it to the correct location. The default location for the data file is /var/mmsuite/central/ If an older mmsuite.db file is already present, you might want to rename it before restoring.

  4. Start Men & Mice Central by issuing the following command:

    sudo /etc/init.d/mmcentral start

Mac OS X

To restore the SQLite database file on Mac OS X:

  1. Install Men & Mice Central, if necessary.
  2. Stop Men & Mice Central by issuing the following command:

    sudo /Library/StartupItems/mmCentral/mmCentral stop
  3. Restore the mmsuite.db data file by copying it to the correct location. The default location for the data file is /var/mmsuite/central/ If an older mmsuite.db file is already present, you might want to rename it before restoring.
  4. Start Men & Mice Central by issuing the following command:

    sudo /Library/StartupItems/mmCentral/mmCentral start