3.6.1 Procedure 15 TRANSFER DATABASES TO MATE

Note:

If the backups are transferred to a remote server, then it is recommended that the remote server has at least 100Mbps network bandwidth and 100G diskspace.

Table 3-19 Procedure 15 TRANSFER DATABASES TO MATE

STEP # A B This procedure transfers the database backup from the one ELAP to the APPD ELAP or remote server. Estimated time: 30-60 minutes

1.

☐

☐

MPS X:

Login as elapdev.

login: elapdev

Password: <elapdev_password>

2.

☐

☐

MPS X:

Verify Connectivity with the APPD card.

If the APPD card cannot be pinged, check the network connectivity. 

$ ping <APPD IP> –c 3 
PING 192.168.3.2 (192.168.3.2) 56(84) bytes of data. 64 bytes from mate (192.168.3.2): Icmp_seq=0 ttl=64 time=0.118 ms 
64 bytes from mate (192.168.3.2): icmp_seq=1 ttl=64 time=0.102 ms 
64 bytes from mate (192.168.3.2): icmp_seq=2 ttl=64 time=0.120 ms 
--- mate ping statistics --- 
3 packets transmitted, 3 received, 0% packet loss, time 
2001ms 
rtt min/avg/max/mdev = 0.102/0.113/0.120/0.011 ms, pipe 2

3.

☐

☐

MPS X:

Change directory to the /var/TKLC/elap/free directory

$ cd /var/TKLC/elap/free

4.

☐

☐

MPS X:

List the EuiDB Backup File in this directory.

NOTE: There will be two npdbBackup listed here. 

#ls –l npdbBackup* 
npdbBackup_xxxxx-a_xxxxxxxx.sql.gz npdbBackup_yyyyy-a_yyyyyyyy.sql.gz 
Please update the ownership of files to elapdev:elap by below command before transferring. Backup is taken from root user, it will be having ownership as root:root. 
# su – 
Password: <root password> 
# cd /var/TKLC/elap/free 
#chown elapdev:elap npdbBackup_xxxxx-a_xxxxxxxx.sql.gz 
#chown elapdev:elap npdbBackup_yyyyy-a_yyyyyyyy.sql.gz 
#su – elapdev 
# cd /var/TKLC/elap/free

5.

☐

☐

MPS X:

Copy the EuiDB Backup

File to the remote /mate server.

NOTE: This backup

will be used in case the full upgrade is not successful. 

$ scp –p npdbBackup_xxxxx-a_xxxxxxxx.sql.gz elapdev@<APPD IP>:/var/TKLC/elap/free  
Or 
$ sftp elapdev@<REMOTE IP> 
Connecting to <REMOTE IP>... 
The authenticity of host '<APPD IP>' 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 '<REMOTE IP>' (DSA) to the list of known hosts. elapdev<REMOTE IP>'s password:  
sftp> cd /var/TKLC/elap/free 
sftp> p‘t npdbBackup_’xxxx’a_xxxxxxxx.sql.gz Uploading npdbBackup_xxxxx-a_xxxxxxxx.sql.gz to npdbBackup_xxxxx-a_xxxxxxxx.tar 
sftp> bye

6.

☐

☐

MPS X:

Copy the

EuiDB‘mysqldump

Backup File to the remote/mate server.

NOTE: This mysqldump of EuiDB will be used for restoring EuiDB after the full upgrade is successful. 

$ scp –p npdbBackup_yyyy-a_yyyyyyyy.sql.gz elapdev@<APPD IP>:/var/TKLC/elap/free  
Or 
$ sftp elapdev@<APPD IP> 
Connecting to <APPD IP>... 
The authenticity of host '<APPD IP>' 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 '<APPD IP>' (DSA) to the list of known hosts. elapdev<APPD IP>'s password:  
sftp> cd /var/TKLC/elap/free 
sftp> p‘t npdbBackup_’yyy-’_yyyyyyyy.sql.gz  Uploading npdbBackup_yyyy-a_yyyyyyyy.sql.gz to npdbBackup_yyyy-a_yyyyyyyy.sql.gz‘’ 
sftp> bye

7.

☐

☐

MPS X: Note down the timestamp in log.

Run the following command:

$ date

This procedure is complete!