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. For more information, refer to the OneSpan Authentication Server Administrator Guide.

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.

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