Update a FTP using sexec and also update database

1 - Install Tunnelier http://capacitacionrapida.blogspot.com/2009/04/tunnelier.html

2 - Create a bat file whit this (only for windows)  

sexec username@domain.com -pw=password -cmd="svn update /var/www/html/proyect/ --username svnuser --password svnpassword"

 

mysqldump -umysqluser -pmysqlpassword -h developmenthost database --ignore-table=database.accesslog --ignore-table=database.cache --ignore-table=database.cache_block --ignore-table=database.cache_content --ignore-table=database.cache_filter --ignore-table=database.cache_form --ignore-table=database.cache_location --ignore-table=database.cache_menu --ignore-table=database.cache_page --ignore-table=database.cache_update --ignore-table=database.cache_views --ignore-table=database.watchdog > temp5.sql

mysql -h host_to_export -umysqluser -pmysqlpassword database < temp5.sql

pause