Question

Four-lines script to make an immediate DB and document root zip backup

What do you think of my four-lines script to make an immediate DB and document root zip backup?

Any flaw you might find. Please inform me of it:

#!/bin/bash
mysqldump -u root -p --all-databases | zip ${drt}/db-$(date +\%F-\%T).zip
zip -r all_zipped-$(date +\%F-\%T).zip ${drt}/ -x "*/cache/*"
rm -rf  ${drt}/db-$(date +\%F-\%T).zip
Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

If you use wordpress here is a semi-portable script to dump the database Takes the DB credentials from the wp-config.php file

#!/usr/bin/env bash

DATE=$(date +%Y%m%d)

BAK_DIR="${HOME}/backups"
WWW_DIR="${HOME}/public_html"

DBNAME=$(grep DB_NAME "${HOME}/public_html/wp-config.php" | cut -d "'" -f 4)
DBUSER=$(grep DB_USER "${HOME}/public_html/wp-config.php" | cut -d "'" -f 4)
DBPASS=$(grep DB_PASSWORD "${HOME}/public_html/wp-config.php" | cut -d "'" -f 4)

mysqldump -u${DBUSER} -p${DBPASS} ${DBNAME} > ${BAK_DIR}/db/${DBNAME}-${DATE}.sql