Skip to content

Instantly share code, notes, and snippets.

@skatsuta

skatsuta/mysqldump.sh

Last active May 5, 2016 06:32
Show Gist options
  • Save skatsuta/17a311fc708f8366d618 to your computer and use it in GitHub Desktop.
Save skatsuta/17a311fc708f8366d618 to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump command
Raw
mysqldump.sh
#!/bin/bash
DATABASE="$1"
TABLE="$2"
mysqldump
--user=username \
--password=password \
--complete-insert \
--quick \
--no-create-db \
--verbose \
"${DATABASE}" "${TABLE}" > "dump_${DATABASE}_${TABLE}_`date +%Y-%m-%d`.sql"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment