distal-attribute
distal-attribute
distal-attribute
distal-attribute

Feature request: Export option missing

User, date Message
Written by Mbird
3 years ago
Category: Import/Export
3 posts since Mon, 29 Mar 10
I'm missing an option for export:

There are two options for "Output":

1. "One big file"
2. "Directory - one file per object..."

Between those two options I'm missing "One file per database".

Would this be possible?
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
No, that's already what "Directory - one file per object in database subdirectories" is for. I think more options will just create more confusion here.
Written by Mbird
3 years ago
3 posts since Mon, 29 Mar 10
Does it mean that nobody wants just "one file per database" as an export option?
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
That's not what I said. I'm just sure there should be some overviewable set of output options.
Written by Mbird
3 years ago
3 posts since Mon, 29 Mar 10
OK, for me it would be very overviewable to have those options:

1. "One big file"
2. "One file per database"
3. "Directory - one file per object..."
...

But of course it's your script.

BTW: Thanks a lot for your script. I'm using it since many years from the beginning on (MySQL-Front).
Written by mmarsching
3 years ago
12 posts since Wed, 19 Jul 06
I'm asking myself, why there is an option to EXPORT each table in one file, but no way to IMPORT multiple files at once?

I have 6 DBs with around 200 tables - a big mess if I try to import them one by one... :(
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
You can load multiple files into one file per query tab.

To be honest, I never understood the need of having an output option for one file per table - implemented as requested long time ago and now I'm scratching my head why I did that.
Written by sh2ka
3 years ago
35 posts since Mon, 29 Nov 10
I think so too (as `anse`). Tables in database often have reletions and saving table per file is meaningless.
By the way where I can upload sql-file in this forum?
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
NowheresmileYou can paste code here wrapped in a code block (blue button).
Written by lemon_juice
3 years ago
128 posts since Tue, 29 Jun 10
Sometimes I use "one file per table" but not often. Like the OP I would prefer "one file per database" option, which would be very useful for multiple db backups. Currently I can only backup to a single file, which can be very messy, I prefer to keep databases separated.
 

Please login to leave a reply, or register at first.