M
DownloadReleasesGuidesChatbotAccountantsForumCloud Edition

Corrupt Database

Manager.io uses SQLite databases to store your accounting data. While SQLite databases are generally robust, they can become corrupted due to hardware malfunctions or rogue programs. This guide will help you recover data from a corrupt Manager.io database file using the SQLite Command Line Interface (CLI).

Prerequisites

  • Access to your corrupt Manager.io database file (*.manager file).
  • A computer with command line access.
  • An internet connection to download the SQLite CLI.

Steps to Recover a Corrupt Database

1. Download the SQLite CLI

The SQLite CLI is a program named sqlite3 that allows you to interact directly with SQLite databases.

  • Visit the SQLite Download Page.

  • Download the precompiled binaries for your operating system:

    • Windows: Look for sqlite-tools-win-x64-*.zip
    • Mac OSX: Look for sqlite-tools-osx-x64-*.zip
    • Linux: Look for sqlite-tools-linux-x64-*.zip

2. Unzip the Downloaded Archive

  • Extract the contents of the downloaded zip file into a new folder on your computer.

3. Prepare the Corrupt Database File

  • Copy your corrupted Manager.io database file (with the extension *.manager) into the folder where you extracted the SQLite tools.
  • Rename your corrupted database file to corrupted.manager for easier reference.

4. Run the Recovery Command

  • Open a command line interface:

    • Windows: Open Command Prompt.
    • Mac/Linux: Open Terminal.

  • Navigate to the folder containing the sqlite3 executable and the corrupted.manager file. Use the cd command to change directories. For example:

    cd /path/to/sqlite/tools/folder

  • Run the following command to attempt recovery:

    sqlite3 corrupted.manager ".recover" | sqlite3 new.manager

    This command attempts to recover the database and creates a new database file named new.manager.

5. Import and Open the Recovered Database

  • After the recovery command completes, ensure that a new file named new.manager has been created in the folder.
  • Open Manager.io.
  • Import new.manager into Manager.io as a new business. For detailed instructions, see Importing Businesses.

6. Verify Your Data

  • Once imported, open the business in Manager.io.
  • Review your data to ensure that the recovery was successful.

Additional Information

Following these steps can help you recover data from a corrupt Manager.io database file. If you continue to experience issues, consider restoring from a backup or contacting Manager.io support for further assistance.