#!/bin/bash
#
##
#
# Export all mysql databases
#
##

rm database.zip

mysqldump kp_phoenix --add-drop-table --complete-insert --default-character-set=latin1 -u kp_pnmonkey -pbuster      > remote_kp_phoenix.sql
mysqldump kp_stuff   --add-drop-table --complete-insert --default-character-set=latin1 -u kp_buster   -phollywood   > remote_kp_stuff.sql
mysqldump kp_ekp     --add-drop-table --complete-insert --default-character-set=latin1 -u kp_ekp      -pk0na        > remote_kp_ekp.sql
mysqldump kp_ffab    --add-drop-table --complete-insert --default-character-set=latin1 -u kp_ffab     -pffab        > remote_kp_ffab.sql

zip database.zip remote_kp_phoenix.sql remote_kp_stuff.sql remote_kp_ekp.sql remote_kp_ffab.sql

rm remote_kp_phoenix.sql
rm remote_kp_stuff.sql
rm remote_kp_ekp.sql
rm remote_kp_ffab.sql