A series of files to include in your git directory in order to automate WordpPress database syncs.

db_local.sql

USE DBNAME_LOCAL;  
UPDATE wp_EXT_options SET option_value="http://LOCALURL:8888" WHERE option_name="siteurl";  
UPDATE wp_EXT_options SET option_value="http://LOCALURL:8888" WHERE option_name="home"; 

db_remote.sql

USE DBNAME_REMOTE;  
UPDATE wp_EXT_options SET option_value="http://REMOTEURL.com" WHERE option_name="siteurl";  
UPDATE wp_EXT_options SET option_value="http://REMOTEURL.com" WHERE option_name="home"; 

pull_to_local.sh

git pull https://REMOTE-REPOSITORY-URL.git
cd db  
mysql -uUSERNAME -pPASSWORD DBNAME < db_sync.sql  
mysql -uUSERNAME -pPASSWORD DBNAME < db_local.sql

pull_to_remote.sh

git pull https://REMOTE-REPOSITORY-URL.git
cd db  
mysql -hREMOTEHOSTNAME -uUSERNAME -pPASSWORD DBNAME < db_sync.sql  
mysql -hREMOTEHOSTNAME -uUSERNAME -pPASSWORD DBNAME < db_remote.sql 

push_from_local.sh

mysqldump -uUSERNAME -pPASSWORD DBNAME > db/db_sync.sql

# If using MAMP and getting a socket error
# mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
# Specify the socket in the mysqldump command by using the line below instead
#
# mysqldump --socket=/Applications/MAMP/tmp/mysql/mysql.sock -uUSERNAME -pPASSWORD DBNAME > db/db_sync.sql

push_from_remote.sh

mysqldump -hREMOTEHOSTNAME -uUSERNAME -pPASSWORD DBNAME > db/db_sync.sql