Friday, February 18, 2011

Generate mySql Script


I am using Linux Ubuntu 10.x Os


1.Open 'MySql Workbench 5.2.31'

2.Select your Default Database

3.Select 'Database' option In menu bar

4.Then Select 'Reverse Engineer' or press 'ctrl+R'

5.It Will Open A 'model' Window Dont Close it

6.Then select 'File' option in menu bar

7.Select 'Export' then Select 'Forward Engineer Sql Create Script ' option
   /Ctrl+Shift+G it Will open a new Window

8.Click 'Browse' Window Save Your File As '.sql' Extension

9.Then Tick Wanted Options In that Window then Click 'Next' button

10.Then Tick wanted Options.This will import wanted tables into sql Script
     You can Select Views as well as Triggers

11.Then Click 'Next' Button(you Can see Generated Sql Script)

12.Click 'Finish'...Its Done!!!