Feature request: Automatically generate filename

[expired user #8505]'s profile image [expired user #8505] posted 9 years ago in Feature discussion Permalink
Hello,

I've been using HeidiSQL for years, and it's awesome.

When right clicking on a database -> Export database as SQL, the file name is saved from the last export. A nice thing to have would be for the file name to be automatically filled with the databases name you are exporting. And maybe a timestamp after it.

Thanks :)
kalvaro's profile image kalvaro posted 9 years ago Permalink
For this precise reason I tend to avoid hard-coded names in the export dialogue. Instead, I use something like this:

C:\Users\whatever\Desktop\%db %y-%m-%d %h-%i.sql


This way, it doesn't matter if it's reused :)
ansgar's profile image ansgar posted 9 years ago Permalink
That input box supports some placeholders, like %db for the database name and %date for date/time. Just hover over that input box and let the tooltip show you some more of these placeholders.
[expired user #8505]'s profile image [expired user #8505] posted 9 years ago Permalink
Wow, how could i have not seen that?

Thank you!
alfiqmiq's profile image alfiqmiq posted 8 years ago Permalink

Replacements (patterns) - i didn't found this in help so i wrote it here

%host   hostname
%u  username
%date   date and time
%db database
%y  year
%m  month
%d  day of month
%h  hour
%i  minute
%s  second

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