mysqldump

#! /bin/sh 
ssh dev.monserveur.com 'mysql --skip-column-names -umonadmin -pmonmotdepasse -e "show databases WHERE `Database` LIKE "%mesbases%"" | while read dbname; do mysqldump --lock-all-tables -umyadmin -pmy2166 "$dbname" | gzip> /tmp/"$dbname".sql.gz; done'

#! /bin/sh 
faire(){
	echo $1
	ssh dev.monserveur.com  'mysql --skip-column-names -umonadmin -pmonmotdepasse '$1' -e "show tables" | while read table_name; do mysqldump --lock-all-tables -umonadmin -pmonmotdepasse '$1' "$table_name" | gzip> /tmp/"$table_name".sql.gz; done'
}


faire "mabase" 

#! /bin/sh 
faire(){
	echo "n faire : "  $1 $2 
	mysqldump  -h dev.monserveur.com  -umonadmin -pmonmotdepasse --lock-tables=false $1 $2 | mysql -usauv -psauv $1
	echo "n fini n"
}

#*******************************************************************
base="mabase"
faire $base banque
faire $base client
faire $base produit

base="mabase2"
faire $base tarif