This section helps first timers to quickly setup MySQL environment so Dbvisit Repicate can be configured after that to establish proof of concept in testing environment.   

If MySQL is not installed then it can be installed with:

 

yum mysql mysql-server

You can start MySQL using following command.

 

/etc/init.d/mysqld start

 

Unlike Oracle, MySQL has no schemas but only databases. Therefore we will create database first before creating table within the new database.

 

mysql> create database scott;
Query OK, 1 row affected (0.00 sec)
mysql> use scott;
Database changed

Now the MySQL table can be created:

 

DROP TABLE IF EXISTS `avi_objects`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `avi_objects` (
`OWNER` varchar(30) default NULL,
`OBJECT_NAME` varchar(128) default NULL,
`SUBOBJECT_NAME` varchar(30) default NULL,
`OBJECT_ID` bigint(20) default NULL,
`DATA_OBJECT_ID` bigint(20) default NULL,
`OBJECT_TYPE` varchar(19) default NULL,
`CREATED` date default NULL,
`LAST_DDL_TIME` date default NULL,
`TIMESTAMP` varchar(19) default NULL,
`STATUS` varchar(7) default NULL,
`TEMPORARY` varchar(1) default NULL,
`GENERATED` varchar(1) default NULL,
`SECONDARY` varchar(1) default NULL,
`NAMESPACE` bigint(20) default NULL,
`EDITION_NAME` varchar(30) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;