mysql_copy_between_servers
Differences
This shows you the differences between two versions of the page.
|
mysql_copy_between_servers [2009/04/25 02:40] k2patel |
mysql_copy_between_servers [2020/08/10 02:35] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Copy all database between servers ====== | ||
| - | NOTE : it not fully written there is many changes needed. | ||
| - | |||
| - | <code bash | mysql_db_cp.sh> | ||
| - | #!/bin/bash | ||
| - | |||
| - | User_nm=<username> | ||
| - | 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')" | ||
| - | |||
| - | for db in ${DBS[@]} | ||
| - | do | ||
| - | if [ "$db" == "$db_skp" ]; then | ||
| - | echo "mysql skipped" | ||
| - | else | ||
| - | echo "syncing database $db" | ||
| - | mysqldump -h $Src_host --user=$User_nm --password=$Passwo $db | mysql -h $Dst_host -u root -pk83apuDrug -D $db | ||
| - | fi | ||
| - | done | ||
| - | </code> | ||
mysql_copy_between_servers.txt ยท Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
