Navigate to folder on server where 'drupal' folder is stored and create a backup tar -cf 17sep19drupal.tar drupal

(please note that when restoring an archive -cf is replaced with -xf)

Copy (or move) the .tar file you have created to your backups folder.

Take a copy of the drupal database mysqldump drupal > dr17sep19.sql     it is a good idea to clear your drupal cache before taking a copy of the database or you will end up with a massive sql file

Copy (or move) the .sql file you have created to your backups folder.

It's probably a good idea to do a local test of the backup - the mysql commands to set up the drupal database locally used are as follows:

create database drupal;

use drupal;

source dr17sep.sql;

if you have previously tested the backup locally then remember to purge the old drupal database

drop database drupal;

show tables; is a handy command for checking how many tables you have

show databases; is a handy command for checking which databases you have

note that the local database will not have a password so edit the drupal settings file for a blank password

note that if you have set up trusted host patterns in the drupal settings file then remove the leading "/" so drupal ignores it

  $settings['trusted_host_patterns'] = [

alternatively you can substitute localhost for the domain name to test locally

  $settings['trusted_host_patterns'] = [

a handy command for checking database sizes is as follows:

SELECT table_schema "DB Name",         ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"  FROM information_schema.tables  GROUP BY table_schema;