abry.rath of UNION Developers
9/28/2018 - 2:09 PM

Checking Database Backups (Proactive Monitoring)

How to work with tarballs to download only the database backup

tar_backups.sh
content_copyfile_download
# List files containing '/mysql/' in the path
tar -tf <tarball> --wildcards '*/mysql/*'

# For example:  
# tar -tf /backup/2018-09-28/accounts/cookebieler.tar --wildcards '*/mysql/*'   
# cookebieler/mysql/cookebie_staging.create
# cookebieler/mysql/roundcube.sql
# cookebieler/mysql/cookebie_staging.sql
# cookebieler/mysql/cookebie_main.sql
# cookebieler/mysql/cookebie_main.create
# cookebieler/mysql/openfileslimit
# ...

# Extract only one file
tar -xf <tarball> <filename>

# For example:
# tar -xf /backup/2018-09-28/accounts/cookebieler.tar cookebieler/mysql/cookebie_main.sql
# produces the directory structure cookebieler/mysql/cookebie_main.sql in the current directory
# 
# To skip the leading directories, add --strip-components 2 to the command, e.g.
# tar -xf /backup/2018-09-28/accounts/cookebieler.tar cookebieler/mysql/cookebie_main.sql --strip-components 2