#!/bin/bash
set -euo pipefail
CONF=~/ridin/dolibarr/htdocs/conf/conf.php
val(){ php -r "include \"$CONF\"; echo \$dolibarr_main_db_$1;"; }
H=$(val host); U=$(val user); N=$(val name); P=$(val pass); PT=$(val port)
PT=${PT:-3306}
OUT=~/ridin/backup-ridindol-${1:-manuel}-$(date +%Y%m%d-%H%M%S).sql.gz
MYSQL_PWD="$P" mysqldump -h "$H" -P "$PT" -u "$U" \
  --single-transaction --routines --triggers --events \
  --default-character-set=binary --hex-blob "$N" | gzip -6 > "$OUT"
ls -lh "$OUT"
echo "tables : $(zcat "$OUT" | grep -c '^CREATE TABLE')"
echo "fin    : $(zcat "$OUT" | tail -1)"