faqts : Computers : Databases : MySQL : Design

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 3 people (67%) answered Yes
Recently 2 of 3 people (67%) answered Yes

Entry

Database: Design: MicroOLAP Database Designer for MySQL: Project: Create: How to create project?

May 8th, 2005 06:18
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 24 April 2005 - 11:23 pm ----------------------

Database: Design: MicroOLAP Database Designer for MySQL: Project: 
Create: How to create project?

---

Steps: Overview:

 1. -Download and install the program MicroOLAP Database Designer for 
MySQL

      http://www.microolap.com/products/database/mydesigner/?
r1=torry&r2=sponsored

 2. -Run this program

 3. -Create a new project

     1. -Select from menu option 'File'

     2. -Select from list 'New'

 4. -Start your MySql server

     1. Run the program

         mysqld-nt.exe

 5. -Connect to a database

     1. -Select from menu option 'Database'

     2. -Click button 'Add'

     3. -In the right pane click on 'Database'

         1. -This should show a list of your MySql database

             1. -Select a database from this list

                  e.g.

                   MyDatabase

     4. -Click button 'OK'

 6. -Now do some operations on this database

     1. -E.g. Show the tables in this database

         1. -Select from menu option 'Database'

         2. -Select from list 'Reverse engineer MySql database'

         3. -Click button 'OK'

             1. -You should now see the diagram of the tables
                 in this database

     2. -E.g. Copy a table of this database

         1. -Click right on any of this tables

         2. -Select from list 'Copy'

         3. -Click on the form

         4. -Right click

             1. -Select from list 'Paste'

    3. -E.g. Change a table of this database

         1. -Double click on any of this tables

         2. -Select tab 'Columns'

         3. -Edit possibly

---
---

Internet: see also:

---

Database: Design: MicroOLAP Database Designer for MySQL: Link: Can you 
give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/36020/fid/1803

----------------------------------------------------------------------