User Tools

Site Tools


mysql_copy_between_servers

Copy all database between servers

NOTE : it not fully written there is many changes needed.

| mysql_db_cp.sh
#!/bin/bash
 
#----------change following
 
#destination username
d_User_nm=<username>
 
#destination password
d_Passwo=<password>
 
#source username
s_User_nm=<username>
 
#source password
s_Passwo=<password>
 
 
Src_host=<source_server>
Dst_host=<Destination_server>
db_skp=mysql
 
#------------no further
 
DBS="$(mysql -h $Src_host --user=$s_User_nm --password=$s_Passwo -Bse 'show databases')"
 
for db in ${DBS[@]}
do
if [ "$db" == "$db_skp" ]; then
echo "mysql skipped"
else
echo "syncing database $db"
mysqldump  -h $Src_host --user=$s_User_nm --password=$s_Passwo $db | mysql -h $Dst_host -u $d_User_nm -p$d_Passwo -D $db
fi
done
mysql_copy_between_servers.txt · Last modified: 2009/04/24 22:43 by k2patel