# Restore a MariaDB Cluster from a Backup

With IONOS Cloud DBaaS, you may roll back your MariaDB clusters to a previous point in time or use it to create a new cluster. This reliable function prevents data loss and downtime in unexpected situations.

For example, consider that certain values were accidentally deleted from your MariaDB cluster around 11 hours today. The easiest way to recover missing data is to restore a backup before 11 hours.

{% hint style="success" %}
**Result:** You can restore only one backup at a time, and you must wait for the restoration process to finish before restoring another backup.
{% endhint %}

## Restore a Cluster

{% hint style="info" %}
**Prerequisites:**

* The backup must belong to the MariaDB cluster to be restored.
* The cluster must be in the **AVAILABLE** state.
  {% endhint %}

To restore a cluster, follow these steps:

1\. In the **DCD**, go to **Menu** > **Databases** > **MariaDB**.

2\. Select a MariaDB cluster from the list by clicking on its name. Alternatively, click **Details** in the **OPTIONS** column.

![Select the respective MariaDB cluster from the list](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-6850f0b8a0776e3f8d460c0239ce0f6970ca3e63%2Fview-mariadb-clusters.png?alt=media)

3\. The **Details** window displays the necessary information of the chosen cluster. For more information, see [<mark style="color:blue;">View the list of MariaDB Clusters</mark>](https://docs.ionos.com/sections-test/guides/databases/mariadb/dcd-how-tos/view-mariadb-clusters).

* **Point In Time Recovery** displays the earliest backup available for restoration. Select **Restore backup** to choose the date and time for backup restoration.

![Point in time recovery option](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-03f066c7a5b3d3063c2554c4d8ea7929bfd2e1ed%2Fmariadb-self-restore-recovery.png?alt=media)

a. In the **Restore backup** pop-up window, click within the text box to open the Calendar.

b. Backups are available only for those dates that are available for selection. Select a date and click **Ok**.

c. Select the **Clock** icon to set a time for restoring the appropriate backup from the chosen day and click **Ok** to confirm your selection.

d. Select **Restore** to proceed with the restoration.

e. Select **Restore** to confirm the restoration.

![Confirm restoration](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-d329583bedce2f90595fffffdb648cf7b77085e3%2Fmariadb-self-restore-recovery-confirm-restore.png?alt=media)

{% hint style="success" %}
**Result:** You will receive a confirmation that the cluster will be restored, and the respective cluster's **STATE** is set to **RESTORING**.
{% endhint %}

![Restoration is in progress](https://1737632334-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MifAzdGvKLDTtvJP8sm%2Fuploads%2Fgit-blob-1a49f36914852250dfc5997c5bd3bc6e87518177%2Fmariadb-restoring.png?alt=media)