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

Question

I need 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

alternate tool - dbForge Studio for MySQL (backup or generate schema script features); objects you can select in a GUI tree. — Devart
– Devart, Commented Mar 31, 2011 at 10:32
one more tool is a mysqldump command line program, you could use with a '--no-data' and '--routines' options — Devart
– Devart, Commented Mar 31, 2011 at 10:35

BJ Patel · Accepted Answer · 2011-04-01 05:46:51Z

3

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"

answered Apr 1, 2011 at 5:46

BJ Patel

6,28811 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BigFatBaby · Accepted Answer · 2011-03-31 10:35:09Z

2

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

answered Mar 31, 2011 at 10:35

BigFatBaby

1,4989 silver badges19 bronze badges

2 Comments

Devart Over a year ago

mysqldump can connect to remote machine too.

BigFatBaby Over a year ago

@Devart : you are absolutely correct, however not all machines have MySQL installed on them, so seeing as he already stated he has Toad installed i thought it would be more helpful to point him in a direction he will surely be able to use

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related