#!/bin/bash
NOW=`date +%Y%m%d%H%M%S`
GIT_MYSQL=/home/backup/mysql-schema
for T in `mysql -u root -N -B -e 'show tables from xxxxxx'`;
do
    echo "Backing up $T"
    mysqldump -d --skip-comments -u root xxxxxx $T | sed 's/ AUTO_INCREMENT=[0-9]*//g' > $GIT_MYSQL/$T.sql
done;
git add -A && git commit -m "schema from $NOW" && git push