Create backup

tar cfvz name_of_web_2018-12-19.tar.gz -C /path/to/your/web .

# Exclude folders, example:
tar cfvz webfolder-2020-08-10.tar.gz -C /mnt/web203/htdocs . --exclude='folder1' --exclude='folder2'

mysqldump --opt --no-tablespaces -h localhost -u db_username -p db_name > backup_name_2018-12-19.sql

tar xvfz backup.tar.gz

mysql -h localhost -u db_username -p db_name < name_of_backup.sql