sync.sh
rsync -avz /var/www/folder/ root@100.100.100.1000:/var/www/folder/
rsync -avz --exclude-from="excludes" ./root/ user@host:/var/www/
excludes
.git .gitignore upload/
MySQL database rsync (db_sync.sh)
Copy MySQL Database From One Server To Another Remote Server
MySQL: Exporting, Backup and Restore
mysqldump --user=username --password=password --add-drop-table database_name | ssh user@host mysql --user=username --password='password' database_name