Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [syncuser@Staging staging]$ cat sync.sh
- #!/bin/sh
- ProdDBHost="ProductionDB.local"
- ProdAlfrescoHost="ProductionAlfresco.local"
- TomcatHome="/usr/local/apache-tomcat-6.0.18"
- #Stop catalina and clean up
- "${TomcatHome}/bin/catalina.sh" stop -force
- rm -rf "${TomcatHome}/work/Catalina"
- #Sync DB
- mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u1 --password=p1 --host="${ProdDBHost}" db1 | mysql --user=u1 --password=p1 db1 &
- mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u2 --password=p2 --host="${ProdDBHost}" db2 | mysql --user=u2 --password=p2 db2 &
- mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u3 --password=p3 --host="${ProdDBHost}" db3 | mysql --user=u3 --password=p3 db3 &
- mysqldump --quick --max_allowed_packet=1G --extended-insert --user=u4 --password=p4 --host="${ProdDBHost}" db4 | mysql --user=u4 --password=p4 db4 &
- #Sync Alfresco
- rsync -avz --delete "${ProdAlfrescoHost}":/alfresco/ /alfresco/ >> /var/staging/alfresco_rsync.log &
- #Wait for all of the above to complete
- wait
- #Resume catalina
- "${TomcatHome}/bin/catalina.sh" start
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement