---
title: "How to: Restoring Databases on a server with an MMA for cPanel/WHM Server"
slug: "how-to-restoring-databases-on-a-server-with-an-mma-for-cpanelwhm-server"
updated: 2026-07-08T01:29:21Z
published: 2026-07-08T01:29:21Z
canonical: "docs.serversaustralia.com.au/how-to-restoring-databases-on-a-server-with-an-mma-for-cpanelwhm-server"
---
> ## Documentation Index
> Fetch the complete documentation index at: https://docs.serversaustralia.com.au/llms.txt
> Use this file to discover all available pages before exploring further.
# How to: Restoring Databases on a server with an MMA for cPanel/WHM Server
Please note:
The following guide is only relevant to customers with a cPanel or WHM server who also have an active Monitoring and Maintenance Agreement (MMA) attached to the server.
To restore databases older than the last 24 hours, simply use Veeam, Acronis, or R1Soft to restore the cpmove file/s located in **/home/r1softtemp** from an older restore point. Once the older cpmove file is restored you can continue the guide below.
For databases specifically, you have the option of using the **cpmove** file that resides within the **/home/r1softtemp** directory**.**
## Example:
To restore using the database from the cpmove file within **/home/r1softtemp**, you can extract the SQL using the following method.
Find your user (I will be using **"acctest"** for this example). Then find the cPanel account, along with the time the backup was done using the below example.
```shell
# cd /home/r1softtemp/
# ls acctest -lah
root@server [/home/r1softtemp]# ls acctest -lah
-rw------- 1 root root 6.3M May 6 02:26 cpmove-acctest.tar.gz
```
You will see that there is a backup from ***2:26 AM***, on ***May 6th****.*
To list the SQL files within this backup, you can use the following command against the cpmove file.
root@server [/home/r1softtemp] cpmove-acctest/psql_grants.sql cpmove-acctest/mysql/ cpmove-acctest/mysql/openfileslimit cpmove-acctest/mysql/acctest_test.sql cpmove-acctest/mysql.sql cpmove-acctest/psql/ cpmove-acctest/psql_users.sql
This gives a list of all available databases (excluding **'mysql-timestamp'** files and **'.create'** files, which are not required for us).
If I want to extract the **acctest_test** database, I would use the following command
As you can see, this extracts only the file itself.
root@server [/home/r1softtemp] cpmove-acctest cpmove-acctest/mysql cpmove-acctest/mysql/acctest_test.sql
To restore this file, it is recommended to take a backup of the already existing database in case you run into any problems:
You will then be able to restore the database using the following command:
Depending on the size of the database file, it may take a few seconds or a few minutes to complete successfully - some patience may be required.