Populate CNCC Database with CNCC IAM Tables

The user must load the CNCC database created with cnccdb_<version>.sql file provided in the cncc-custom-configtemplatepackage file. This section describes how to polulate CNCC database with CNCC IAM tables.

1. Load the database with tables from cnccdb_<version>.sql. Ensure cnccdb_<version>.sql is in /home/admusr/directory of the MySql Query Node.

   mysql -u <username> -p <databasename> cnccdb_<version>.sql

   Note:

   The user must enter the mysql password.
2. Verify the tables are loaded into the database using command:

   $ use <databasename>;

   $ show tables;

   Note:

   It shows a list of 93 tables related to CNCC-IAM.
3. Exit from MySql Query Node using following command:

   $ exit;

Example to demonstrate loading of cnccdb with tables from cnccdb_<version>.sql:

#mysql -h 127.0.0.1 -uroot -pNextGenCne cnccdb < /home/admusr/cnccdb.sql 
#mysql -h 127.0.0.1 -uroot -pNextGenCne 
mysql>use cnccdb; 
mysql> show tables;