Restoring a Filesystem backup Using a Tarsnap backup

--Restoring a Filesystem backup Using a Tarsnap backup--

#1.Check tarsnap to find the archive you want
tarsnap --list-archives | sort

#2. Download from tarsnap
tarsnap -x -f 2019-11-07-hostedsites

#3 unzip
tar zxf backupname.tar.gz

#4 Rename original directory and replace with backup
#a) mv /home/username/public_html /home/username/pub_hack
#b) mv tarsnapdir/public_html /home/username/public_html

#5 Reload nginx.
systemctl reload nginx

--Restoring a Database Backup--
#To restore a single database:
mysql -u root -p [database_name] < backupname.sql

#To restore all databases (tables need to exist, or backup needs to contain CREATE TABLE statements):
mysql -u root -p < alldatabases.sql