> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.serverfreak.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Restore File and SQL Manually

||| WARNING: Kindly note that this tutorial is meant for reference. Some of these commands may be dangerous to be handled by a non-experience server admin/user and could lead to loss of data, and a non-functional server that may require reinstallation. Use the tutorial/command below at your own risk.


In WHM > Terminal

--
To get the document root of the domain

`grep domainname /etc/userdatadomains`

--
Step 1: Go to the domaindocumentroot

Example: `cd /home/cpanelusername/public_html/`

Step 2: Dump MYSQL

`mysqldump sqlname > sqlname.sql`

Step 2.5: Rename the folder and re-create another folder with same name with the previous name

Step 3: Find the backup folder 

```
cd /home/backup
cd backupdate
cd accounts
cd accountsusername
cd homedir
cd domainnamedocumentroot
```

--
Step 4: After you have found the file backup, kindly run the RSYNC command

`rsync -avzp /backupfolderfulllpath/ /exactdocumentrootpath/`

To check the backup folder full path, kindly run this command `pwd`

Example of the path that you will get: `/home/backup/2023-02-22/accounts/mangasy/homedir/public_html`

Step 5: Drop MYSQL database

`Go to cPanel > PhpMyAdmin > Choose the database > Check all table > Drop`


![](https://storage.crisp.chat/users/helpdesk/website/30c43b4318b81000/screenshot-106_iokk6d.jpg)

Step 6: Find the backup SQL file

```
cd home/backup
cd bacukpdate
cd accountusername
cd mysql
```

Step 6: Import the database sql file

`mysql sqlname < sqlname.sql`

--
Step 7: Fix the folder permission (make sure you are in right path before running the command)

```
cd /home/cpanelusername/
chown -R cpanelusername:cpanelusername domaindocumentroot
```

Step 8: Change the permission file from 750 to 755

`chmod 755 public_html`