Related

Join the DigitalOcean Community Community

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
 Join Now
I have problem with apt-get install or apt-get update i can't locate any packages or fetch archive server ?? Question Question
Why isnt my cron job working? Question Question

Question

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

Posted February 9, 2018 1.1k views
Linux CommandsUbuntu 16.04

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
Add a comment
benqzq
By:
benqzq

Related

Join the DigitalOcean Community Community

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
 Join Now
I have problem with apt-get install or apt-get update i can't locate any packages or fetch archive server ?? Question Question
Why isnt my cron job working? Question Question

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.

×
Submit an Answer
1 answer
jasonjpeters 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
Reply Report

Related

Looking for something else?

Ask a new question Search for more help