--- title: "Restoring an ODBC database from a backup" slug: "oas-ag-restoring-an-odbc-database-from-a-backup-3-28" updated: 2026-09-16T12:04:16Z published: 2026-09-16T12:04:16Z canonical: "docs.onespan.com/oas-ag-restoring-an-odbc-database-from-a-backup-3-28" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.onespan.com/llms.txt > Use this file to discover all available pages before exploring further. # Restoring an ODBC database from a backup This procedure should be followed if a database has been damaged and no current, valid database exists on another server. The database is restored from an earlier backup. If OneSpan Authentication Server has been **upgraded**, make sure that the backup used to restore the database was taken **after** the upgrade. Restoring a backup that was taken before the upgrade will cause OneSpan Authentication Server to fail. To restore a backup of the embedded MariaDB database 1. In Windows, open a Command Prompt window and navigate to %PROGRAMFILES%\VASCO\MariaDB10.11\bin\. In Linux, open a terminal and navigate to /usr/bin/ or /usr/sbin/, depending on which Linux distribution you are using. 2. Type the following command: mysql db_name --ssl=TRUE -u db_username -p < backup_filename where: When prompted, provide the password for the database administrator account. > By default, the following settings apply to the embedded MariaDB database: > > - db_name (default database name) is Identikey Server. > - db_username (database administrator account name) is digipass. > - db_password (database administrator account password) is digipassword. > This command can only be executed with SSL enabled. - ‑‑ssl=TRUE enables secure connections (TLS) for the database connection. - db_name is the database name, e.g., Identikey Server. - db_username is the user account used for database authentication. - backup_filename is the absolute path and name of the file to restore the data backup, e.g., ./backup.sql. 3. Delete the replication database. To do so, delete Replication.DB in the following directory: If you have configured replication to store its files in a **different directory**, delete the files in that directory instead. - /var/spool/vasco/ias (Linux) - %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server\ReplData (Windows, default) 4. Restart the OneSpan Authentication Server service/daemon. 5. Perform the steps in [Restoring an ODBC database from another OneSpan Authentication Server instance](/sec/docs/oas-ag-restoring-an-odbc-database-from-another-instance-3-28) on all other OneSpan Authentication Server instances in the environment. It is essential to resynchronize all the databases in the system.