kindly suggest the command or steps to perform to export, import mysql netqosportal database on PC

Products

• DX NetOps

Issue/Introduction

What steps need to perform to export, import mysql netqosportal database on PC

Environment

20.2

Cause

we need to use mysqldump to backup and mysql to restore

Resolution

commands to export/import PC mysql databases (netqosportal and em) - 

Login to CAPC server

cd /opt/CA/MySql/bin/

mysqldump --routines netqosportal -unetqos -p{password} > $backupDir/netqosportal.sql 

mysqldump em -unetqos -p{password} > $backupDir/em.sql 

 

Restore databases using the following command: 

cd /opt/CA/MySql/bin 

mysql netqosportal -unetqos -p{password} -e 'source /tmp/netqosportal.sql' 

mysql em -unetqos -p{password} -e 'source /tmp/em.sql'