Skip to end of metadata
Go to start of metadata

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:

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

 

Icon

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:

  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:

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:

  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:

  • No labels