Forums » General Discussion

Thread: How to export EVERYTHING in a database?

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 3 - Pages: 1 - Last Post: Nov 15, 2011 4:53 PM by: Mauritz
pstein

Posts: 27
Registered: 10/21/08
How to export EVERYTHING in a database?
Posted: Sep 22, 2011 12:54 AM
 
  Click to reply to this thread Reply

I want to export EVERYTHING in a database (TABLES, VIEWS, DATA, TRIGGER, STORED PROCEDURES,...) into an SQL script file.
When I click now the menu:

Tools->Export->Export Wizard

and check "Databases" then there are only two subcategories:

- Tables
- Views

What about Data rows, Triggers, Stored Procedures,....?
How can I export really everything into an external SQL file?

Peter



pstein

Posts: 27
Registered: 10/21/08
Re: How to export EVERYTHING in a database?
Posted: Oct 14, 2011 1:54 AM   in response to: pstein
 
  Click to reply to this thread Reply

...no answer?


Rick Alaniz


Posts: 2
Registered: 10/31/11
Re: How to export EVERYTHING in a database?
Posted: Nov 15, 2011 4:43 PM   in response to: pstein
 
  Click to reply to this thread Reply

I'm actually looking for a similar answer.  anyone?  thx.


Mauritz

Posts: 314
Registered: 8/23/07
Re: How to export EVERYTHING in a database?
Posted: Nov 15, 2011 4:53 PM   in response to: Rick Alaniz
 
  Click to reply to this thread Reply

Since this is a piece of functionality that is covered pretty conclusively by the mysqldump utility we have not spent time replicating this functionality in Toad for MySQL I'm afraid.


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums