---
title: "Backing up the data store: Embedded MariaDB database (without password prompt for batch files)"
slug: "oas-ag-backing-up-the-data-store-embedded-mariadb-database-without-password-prompt-for-batch-files-3-27"
updated: 2025-07-04T10:04:42Z
published: 2025-07-07T14:23:10Z
canonical: "docs.onespan.com/oas-ag-backing-up-the-data-store-embedded-mariadb-database-without-password-prompt-for-batch-files-3-27"
---

> ## 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.

# Backing up the data store: Embedded MariaDB database (without password prompt for batch files)

The mysqldump command may also be run via a batch file to automatically create backups at regular intervals. To remove the interactive prompt for the password, you can create an option file to provide the required credentials in a more secure way than via the command line.

> After you create an SQL dump, the dump file will contain unencrypted data which is sensitive in the context of GDPR. To be GDPR-compliant, we recommend to either delete the file, or to encrypt the file, folder, or disk containing this sensitive information.
> 
> For more information about GDPR, refer to the OneSpan Authentication Server General Data Protection Regulation Compliance Guide.

To create a logical backup of the embedded MariaDB database (w/o password prompt)

1. Create an option file with the following content:

> [mysqldump]
> 
> host = localhost
> 
> user = db_username
> 
> password = db_password

where:

> As you need to store the password in plain text, you should protect the option file from unauthorized access!
  - db_username is the user account used for database authentication.
  - db_password is the password used for database authentication.
2. Use the following command line:

mysqldump ‑v ‑‑defaults‑extra‑file=option_file db_name > backup_filename

where:
  - option_file is the full path and name of the option file.
  - db_name is the database name, e.g. Identikey Server.
  - backup_filename is the absolute path and name of the file to store the data backup, e.g. ./backup.sql.

You can create a second database administrator account that only has permission to back up the database.