#!/bin/sh
# Refresh the SQL schema file for inclusion within the git commit

# If something fails, exit with status other than 0
set -e

# first, remove our original schema
cd /var/www
rm -f filename.sql

# generate a new schema
mysqldump -u username --password=password database > filename.sql

# Add the schema to the next commit
git add filename.sql

# Exit success
exit 0

#!/bin/sh
# Refresh the SQL schema file for inclusion within the git commit

# If something fails, exit with status other than 0
set -e

# first, remove our original schema
cd /var/www
rm -f schema.sql

# generate a new schema
mysqldump -u micronet --password=u8i9o0p- micronet > schema.sql

# Add the schema to the next commit
git add schema.sql

# Exit success
exit 0

Git Pre-Commit MySQL Dump / Backup

git

Bash