siumhossain/db.md

Created September 1, 2025 15:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/siumhossain/5afa3c869290b749d4166e5122e02fc7.js"></script>
Save siumhossain/5afa3c869290b749d4166e5122e02fc7 to your computer and use it in GitHub Desktop.

Download ZIP

dump big db

Raw

db.md

Add memory and compression optimizations

Create backup with better memory management

BACKUP_DIR="mysql_backup_$(date +%Y%m%d_%H%M%S)"

mkdir -p "$BACKUP_DIR"

mydumper \
  -u spowner \
  -p "Kutus@@57" \
  -B livemcq \
  -t 2 \
  -o "$BACKUP_DIR/" \
  -c \
  -v 3 \
  --triggers \
  --routines \
  --events \
  --compress \
  --rows=10000 \
  --long-query-guard=7200