ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 226431

calendar_today

Updated On:

Products

DX NetOps

Issue/Introduction

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

Cause

we need to use mysqldump to backup and mysql to restore

Environment

20.2

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'