Introducing DigitalOcean Functions: A powerful, serverless compute solution

Related

Configuring EE Nginx to work with multiple sites. 403 error. help.
Question
Are there Technical Persons for hire to assist this non Technical Person handdling his dropplet
Question

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.

Jason Peters • February 12, 2018

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
Join the DigitalOcean CommunityCommunity

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner

Related

Configuring EE Nginx to work with multiple sites. 403 error. help.
Question
Are there Technical Persons for hire to assist this non Technical Person handdling his dropplet
Question
Join the DigitalOcean CommunityCommunity

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner