> For the complete documentation index, see [llms.txt](https://docs.storware.eu/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.storware.eu/protecting-applications/applications/mysql-mariadb.md).

# MySQL/MariaDB

To create a new application for MySQL database backup, go to the tab: **Applications -> Instances**

Then select the **Create** button. The Creating an Application Definition section will be displayed, which needs to be completed.

This is a description of how your script is going to be invoked - you need to specify:

* **Name** - unique name of the application in the Storware Backup & Recovery system.
* **Choose Node Config** - select which node should perform the task.
* **Backup policy** - specify which backup policy should be used for this application.
* **Command execution configuration** - select a prepared template for MySQL backup or create a [new](/administration/applications/execution-configurations.md) one yourself.

On the SSH access subtab, complete the following fields:

* **Host** - set the address of the host where the MySQL instance exists.
* **Port** - set the host port.

Next, select OS Credentials or create a new one and provide the following information:

* **Name** - unique name of the OS Credentials.
* **User** - indicate a user for SSH connection.
* **Password** - enter the connection password.
* **SSH key path** - alternatively, you can specify the SSH key path for authorization.

After saving the application configuration, define the following environment variables:

#### Environment Variables

| Variable              | Value    | Description                                                                                                                                                                                             |
| --------------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `VP_MYSQL_DBLIST`     | *string* | Comma-separated list of database names to back up.                                                                                                                                                      |
| `VP_MYSQL_SCRIPTPATH` | *string* | Path to the backup script on the target MySQL/MariaDB host. Copy the appropriate script from **/opt/vprotect/server/scripts/application** to the database host. Then provide its destination path here. |
| `VP_MYSQL_STOREPATH`  | *string* | Path on the MySQL/MariaDB server for the temporary backup file. Store no other files there. Storware Backup & Recovery removes all files after the backup finishes.                                     |
| `VP_MYSQL_USER`       | *string* | MySQL/MariaDB login username.                                                                                                                                                                           |
| `VP_MYSQL_LOGFILE`    | *string* | Path on the MySQL/MariaDB server for the backup job log file.                                                                                                                                           |
| `VP_MYSQL_PASSWORD`   | *string* | Database user password.                                                                                                                                                                                 |

{% hint style="info" %}
**Note:** After the new application is fully configured, **save** the changes and go to the [Backup SLAs](/administration/applications/backup-slas.md) configuration.
{% endhint %}