This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
mysql_copy_between_servers [2009/04/25 02:39] k2patel |
mysql_copy_between_servers [2009/04/25 02:43] k2patel |
||
---|---|---|---|
Line 6: | Line 6: | ||
#!/bin/bash | #!/bin/bash | ||
- | User_nm=<username> | + | #----------change following |
- | Passwo=<password> | + | |
+ | #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> | Src_host=<source_server> | ||
Dst_host=<Destination_server> | Dst_host=<Destination_server> | ||
db_skp=mysql | db_skp=mysql | ||
- | DBS="$(mysql -h $Src_host --user=$User_nm --password=$Passwo -Bse 'show databases')" | + | #------------no further |
+ | |||
+ | DBS="$(mysql -h $Src_host --user=$s_User_nm --password=$s_Passwo -Bse 'show databases')" | ||
for db in ${DBS[@]} | for db in ${DBS[@]} | ||
Line 20: | Line 35: | ||
else | else | ||
echo "syncing database $db" | echo "syncing database $db" | ||
- | mysqldump -h Src_host --user=$User_nm --password=$Passwo $db | mysql -h Dst_host -u root -pk83apuDrug -D $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 | fi | ||
done | done | ||
</code> | </code> |