Analyzing Ossim Database with MySQL Workbench tool

Source: Internet
Author: User
Tags create database ossim

analyzing Ossim Database with MySQL Workbench tool


MySQL Workbench is a e/r Database modeling tool designed for MySQL. It is a successor to the famous Database design tool DBDesigner4 . You can use MySQL Workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations. MySQL Workbench is the next generation of Visual Database design, management tools, it also has open source and commercialization of two versions. Can run on Windows,Linux,Mac platforms, the following walkthrough is explained under Windows 7.

Objective: Use Workbench Tool Remote analysis Ossim database.

Environment:

l Native access to the virtual machine in the Ossim database .

l This machine IP is a 192.168.0/24 network segment .

l Virtual machines: Vmware Workstation.

l VM: ossim nic in NAT mode .

l Ossim IP :192.168.120.77 .

l Gateway: 192.168.120.1.

Note: It is recommended that readers do not Use Chinese MySQL Workbench, that program often has unexpected errors.

(1) Setting

in the MySQL Do the following in the , For remote connections , as shown in 1.

(2)for ease of commissioning, theiptables–ftemporarily remove the rule. Next we areWindowsinstalled onWorkbench, start the backupOssimdata. First create a new connection with the nameossim_db, the connection method uses a standardTCP/IPprotocol, and then enterOssimof the hostIPAddress "192.168.120.77", Database Port3306,logged in userRoot,Enter a password,2is shown.


Figure 2 login Screen

(3) The system shows the database process everywhere,3 shows , we should pay attention to the export path.

Figure 3 backing up the database

the process of importing a database is also fairly easy,as shown in 4 .


Figure 4 Importing a database


(4) analyze ossim Database Relationship -(Draw e-r graph)

The first step : Select Database menu under the "Reverse Engineer" button, pay attention to not worry about connecting to the databases. as shown in 5.


Fig . 5 Reverse Engineer

Step Two: Configure the parameters, enter the host IP and Port 6 are shown.

Figure 6 Configuring Hosts IP and Port


Next, choose "conect to DBMS" and "Retrieve Schema List from Database" and select button 7.


Figure 7 connecting the database


Figure 8 Selecting a database


There are four databases in OSSIM4.10 at this point, select one or more as needed, and choose "avcener"here,as shown in 9 . Next choose the Execute button and follow the prompts to select it.

Figure 9

Set the association,as shown in.

Figure View Database Associations


The use of MySQL on the analysis of Ossim Database Workbench more efficient, in the future will introduce you more exciting content.







Analyzing Ossim Database with MySQL Workbench tool

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.