how to generate Data Base DB script in MySQL (MySQL Query Browser / Toad for MySQL)

I need开发者_JS百科 to Generate an export script of entire MYSQL Database ,

currently i am using

      MySQL Query Browser 
  and 
      Toad for MySQL

so How can I Generate the script of entire DB.

As i need to only copy structure of Table , procedures to other DataBase

LogOn to MySQL Administrator.

Click on BackUp --> on the Left Panel

in BackUp Project Tab --> Enter the backUp name in Select Schemata the name of Db you need to generate script / Bk

click on ">"

--> Click on New "Execute Backup Now"

You should use the mysqldump feature of the mysql itself if you are on the machine that the MySQL is installed on.

if you are trying to create a dump from a remote machine you should use the Toad for MySQL Export Wizard