Differences

This shows you the differences between two versions of the page.

--- mysql_copy_between_servers [2009/04/25 02:39] – created k2patel
+++ mysql_copy_between_servers [2020/08/10 02:35] (current) – external edit 127.0.0.1
@@ Line 6: / Line 6: @@
 #!/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>
 Dst_host=<Destination_server>
 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[@]}
@@ Line 20: / Line 35: @@
 else
 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
 done
+</code>