Restore a local database

Restore a local database

Procedure for restoring a local database

Restoring a local database is done using the administration tool corresponding to your database engine: SQL Server, PostgreSQL, MariaDB or MySQL.

Steps to follow

  1. Force all users to exit the application
    Ensure that no user is logged into Cheel before starting the procedure.

  2. Open the database management tool
    Use the appropriate tool for your engine (e.g., SQL Server Management Studio, pgAdmin, etc.).

  3. Save the current database
    Perform a full backup of the existing database.
    Important: Never overwrite your previous backups

  4. Rename the current database
     Rename the production database to keep it in the archive.

    Example: MyCheelDB → MyCheelDB.Archive.YYYY.MM.DD

  5. Restore the database
     Start the restore procedure from the desired backup file.

  6. Check the restoration in Cheel
     Open the Cheel application and check that the restored database is accessible and functional.
Info
Recommendation : always keep several historical backups.