OVERVIEW

If you want the backup at the local machine without using FTP.

STEPS -

1 - Make the compressed file

Take the web ssh of the application/database layer.

Go to the path where the data is stored.

Eg: If its using an apache application layer then it should be /var/www/webroot/ROOT.

Make the .tar, .zip, etc. file of the ROOT folder.

2 - Move the compressed file

Move the compressed file to the document root.

Then give full permission to a compressed file:
chmod 777 root.tar.gz

3 - Browse the compressed file path

/root.tar.gz OR /root.tar.gz.

Note: It should have public IP.

From this, you can download the compressed file at the local machine.

Another way to download the compressed file by command line is

wget http:///root.tar.gz             

OR

wget http:// /root.tar.gz