Feature request: Export option missing

[expired user #4812]'s profile image [expired user #4812] posted 14 years ago in Import/Export Permalink
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?
ansgar's profile image ansgar posted 14 years ago Permalink
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.
[expired user #4812]'s profile image [expired user #4812] posted 14 years ago Permalink
Does it mean that nobody wants just "one file per database" as an export option?
ansgar's profile image ansgar posted 14 years ago Permalink
That's not what I said. I'm just sure there should be some overviewable set of output options.
[expired user #4812]'s profile image [expired user #4812] posted 14 years ago Permalink
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).
[expired user #52]'s profile image [expired user #52] posted 13 years ago Permalink
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... :(
ansgar's profile image ansgar posted 13 years ago Permalink
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.
[expired user #5341]'s profile image [expired user #5341] posted 13 years ago Permalink
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?
ansgar's profile image ansgar posted 13 years ago Permalink
NowheresmileYou can paste code here wrapped in a code block (blue button).
lemon_juice's profile image lemon_juice posted 13 years ago Permalink
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.