Snippets

ByJG MySQL DUMP

Created by Joao Gilberto Magalhaes
mysqldump.sh
Raw 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
mysqldump \
    --skip-lock-tables \
    --single-transaction \
    --hex-blob \
    --triggers \
    --routines \
    --events \
    --master-data=1 \
    --host $HOST \
    -u $USER \
    -p$PASS \
    --databases $DATABASES \
    --port $PORT | sed 's/DEFINER=[^*]*\*/\*/g' > $FILE

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.