How do I generate a script of all database objects in Toad for MySQL

mysql database-schema toad sql-scripts
JohnB picture JohnB · Nov 21, 2010 · Viewed 52.8k times · Source

In the freeware version of Toad for MySQL (latest version), I can generate a script of all tables in my database in one file. However, for stored procedures and functions, Toad generates a separate script/file for each one.

Ideally, I'd like a simple step to generate a script for all objects in my database (tables, views, procedures, functions, triggers) to a single file.

Is that possible in Toad for MySQL?

Answer

JohnB picture JohnB · Nov 22, 2010

I am happy to report that HeidiSQL does exactly what I need it to do. This feature alone is worth having the 3 MB .exe on your system:

alt text

As a bonus, it's lightweight and fast. It can't do everything Toad for MySQL does, but for most tasks, I will default to Heidi instead of SUPER SLOW Toad!

If someone can still answer my question about how to do this operation in Toad for MySQL, I will change my accepted answer.

(and another option I have is using mysqldump)

Related questions

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

Read More
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
How to store arrays in MySQL?

I have two tables in MySQL. Table Person has the following columns: id | name | fruits The fruits column may hold null or an array of strings like ('apple', 'orange', 'banana'), or ('strawberry'), etc. The second table is Table Fruit and …

Read More