I think it would be great if it would be possible to do full database backups (and restores) using Toad! That way it would be possible to move a database from one server to another, without the need for extra software.
Currently I use Toad for everything MySQL. But for one thing only, creating backups and moving databases from one location to another, I always keep Navicat or DataTools (http://www.terasoft.info/downloads/downloads-datatools.tkl, freeware) on the side.
There is an export function in toad, but this only creates SQL-files (or other files) table by table. Depending on the DB structure this can take very long to restore, as each script should be run individually. To make matters worse, you first need to manually re-create the datbase structure, as the SQL only contains 'insert' statements. All in all it can take hours.
With datatools, I can just dump an entire database with one click of the button, and re-create it with another click of the button.
I have spend a long time trying to create a full backup using Toad, but never found any option. I long refused to believe this, because it seems so very basic to me. But perhaps most people are managing their databases in a completely different way than we do, so they have no need for a GUI to be able to backup or move databases. But for me it would be brilliant if I could do all that using Toad.
check out the functions "Schema Compare..." and "Data Compare" under "Tools"/"Compare". Those made my day when migrating a DB/2 schema with data. However, it was a bit bumpy, since the order of tables/stp's isnt maintained according to dependencies (foreign keys or calling stacks).
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
Thanks, DocJones! Indeed using a combination of schema compare and data compare does the trick. But it is incredibly contrived for which is really a basic function.
There is an export wizard that allows us to export to Excel, separate SQL files per table, and many more formats. A lot of advanced options, but simply downloading importing or exporting an entire database is NOT an option.
It just really surprises me. The underlying technology is already there in Toad. Why not allow to download a complete database, upload a complete database or move databases from one server to another with a couple of clicks?
There is so much functionality in Toad. For web developers and other users of 'simple databases', most of this is complete overkill. But for basic functionality we still need to resort to the command line tools or other third party programs. By adding simple import, export and backup functions for complete databases, Toad would become a one-stop shop for everything MySQL. It would be so sweet :)
I agree, a full dump would be great. It would also be great if there was a UI for a person to backup one DB to another DB on a different server. For example, I want to be able to backup my database everyday of the week, i.e. Monday is backup1, Tuesday is backup2,... then on the next week, override backup1 on Monday with the new backup, override backup2 on Tuesday with the new backup,... There might be a better way to backup or a better way to backup in this fashion, but that is my current dilemma.