|
Replies:
7
-
Pages:
1
-
Last Post:
Nov 13, 2012 3:32 PM
by: Cody
|
|
|
Posts:
3
Registered:
4/26/10
|
|
|
|
Backups! Dumps!
Posted:
Apr 26, 2010 12:40 PM
|
|
|
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.
|
|
|
Posts:
50
Registered:
2/22/10
|
|
|
|
Re: Backups! Dumps!
Posted:
Apr 27, 2010 12:57 AM
in response to: Andor
|
|
|
Heyas,
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).
regards
/M
|
Level 197 Nanomage NT from Rimor speaking... err, wait: Wrong Forum!
|
|
Posts:
3
Registered:
4/26/10
|
|
|
|
Re: Backups! Dumps!
Posted:
May 9, 2012 7:58 AM
in response to: Andor
|
|
|
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 :)
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Backups! Dumps!
Posted:
May 10, 2012 11:17 AM
in response to: Andor
|
|
|
We haven't included this in Toad for MySQL because there already is a great tool included with MySQL that does this (mysqldump).
It is fairly easy to use and super fast.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Backups! Dumps!
Posted:
May 10, 2012 11:18 AM
in response to: Mauritz
|
|
|
We might consider adding a more user friendly front end for this tool in Toad for MySQL in a future release.
|
|
|
Posts:
1
Registered:
5/31/12
|
|
|
|
Re: Backups! Dumps!
Posted:
May 31, 2012 6:55 AM
in response to: Mauritz
|
|
|
Hi, this is my first post here,,, And I 'd like very much some front end for mysqldump. thx
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: Backups! Dumps!
Posted:
Sep 18, 2012 12:07 PM
in response to: Andor
|
|
|
Hi Mauritz,
I would like to stress how nice it would be to have full dump (like done with mysqldump) with an easy graphical user interface inside of Toad4mySQL.
I'm often transfer daat from the production environment to a R&D environment, and a full dump would make my life much easier.
There is already the single table export as script, why not doing the next step and including the full dump? 
Otherwise I think Toad4mySQL is an awesome tool.
Thanks
Fred
|
|
|
Posts:
1
Registered:
11/13/12
|
|
|
|
Re: Backups! Dumps!
Posted:
Nov 13, 2012 3:32 PM
in response to: Andor
|
|
|
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.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
