Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PROJECT_NAME='PROJECT_NAME'
- MYSQL_HOST='localhost'
- MYSQL_DB='website'
- MYSQL_USERNAME='root'
- MYSQL_PASS='toor'
- wc_rev=`svn info | grep "Revision" | cut -d ' ' -f2`
- backup_stamp=$PROJECT_NAME'-'`date +"%d-%m-%Y_%H-%M"`'-r'$wc_rev'.sql'
- if [ -f db_schema.sql ];
- then
- echo "Warning: deleting old db_schema.sql, last changed rev "`svn info db_schema.sql | grep "Last Changed Rev" | cut -d ' ' -f4`
- mv db_schema.sql db_schema.sql.bak
- fi;
- echo '-- '$backup_stamp > db_schema.sql
- mysqldump -h$MYSQL_HOST -u$MYSQL_USERNAME -p$MYSQL_PASS $MYSQL_DB >> db_schema.sql
- if [ -f db_schema.sql.bak ];
- then
- diff db_schema.sql.bak db_schema.sql
- echo "Terminate the script now if you want the backup copy"
- sleep 15
- rm -f db_schema.sql.bak
- fi
Add Comment
Please, Sign In to add comment