3.5.4 Procedure 7 Transfer Database to Remote Server

Table 3-12 Procedure 7 - Transfer Database to Remote Server

S T E P # This procedure transfers the database backup from the LSMS server to the remote server. Estimated time: 30 minutesNote: 100mbps link is required for database transfer to remote server.

☐1.

LSMS Active server:

Log in to the server as the user “root”

 
Login: root
Password: <root_password>

☐2.

LSMS Active server:

Verify Connectivity between the LSMS and the remote server.

If the remote server cannot be pinged, verify the network connectivity.

 
# ping <remote IP> –c 3

PING <Remote IP> (<Remote IP>) 56(84) bytes of data.
64 bytes from <Remote IP>: icmp_seq=1 ttl=64 time=0.022 ms
64 bytes from <Remote IP>: icmp_seq=2 ttl=64 time=0.020 ms
64 bytes from <Remote IP>: icmp_seq=3 ttl=64 time=0.020 ms

--- <Remote IP> ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.020/0.020/0.022/0.005 ms

☐3.

LSMS Active server:

List the snapshot files

 
# ls -lrt /var/TKLC/lsms/free/*snapshot*
# ls –lrt /var/TKLC/lsms/free/supDBdump.sql
# ls –lrt /var/TKLC/lsms/free/MySQLUserGrants.sql

☐4.

Remote server:

Remove the existing DB snapshot files

 
# rm /var/TKLC/lsms/free/mysql-snapshot-* 
# rm /var/TKLC/lsms/free/supDBdump.sql
# rm /var/TKLC/lsms/free/MySQLUserGrants.sql

☐5.

LSMS Active server:

Copy snapshot files to a Remote Server.

Transfer all the NPAC region DB snapshot files, the MySQL dump of supDB and the MySQL dump of mysql.user

Note: The NPAC regions are: CanadaDB, MidAtlanticDB, MidwestDB, NortheastDB, SoutheastDB, SouthwestDB, WestCoastDB and WesternDB 

# scp –p /var/TKLC/lsms/free/mysql-snapshot-<NPAC region>.tar.gz root@<Remote IP>:<Remote IP Path> 
Password: <root_password>
# scp –p /var/TKLC/lsms/free/supDBdump.sql root@<Remote IP>:<Remote IP Path>
Password: <root_password>
# scp –p /var/TKLC/lsms/free/MySQLUserGrants.sql
root@<Remote IP>:<Remote IP Path> 
Password: <root_password>

Or

# cd /var/TKLC/lsms/free/
# sftp <username>@<IP address of remote computer> 
Connecting to <IP address of remote computer>...
The authenticity of host '<IP address of remote computer>' can't be established.
DSA key fingerprint is 58:a5:7e:1b:ca:fd:1d:fa:99:f2:01:16:79:d8:b4:24.
Are you sure you want to continue connecting (yes/no)? yes 
Warning: Permanently added '<IP address of remote computer>' (DSA) to the list of known hosts.
<username>@<IP address of remote computer>'s password: 
sftp> cd <target directory>
sftp> put mysql-snapshot-<NPAC region>.tar.gz 
Uploading mysql-snapshot-<NPAC region>.tar.gz
sftp> put supDBdump.sql 
Uploading supDBdump.sql
sftp> put MySQLUserGrants.sql 
Uploading MySQLUserGrants.sql 
sftp> bye

☐6.

Remote Server:

Verify the snapshot files are present on the remote server.

 
# ls -lrt /var/TKLC/lsms/free/*snapshot*
# ls –lrt /var/TKLC/lsms/free/supDBdump.sql
# ls –lrt /var/TKLC/lsms/free/MySQLUserGrants.sql

This procedure is complete!