Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Export as SQL - add a variable for table

5 posts

gerardsweeney posted 3 weeks ago in Feature discussion

If I'm working on a couple of tables on a daily basis, I'd like the "Export as SQL" GUI to include a variable so that I can have it save as the table as "C:\Backups\%db%table%day%mon%year.sql".

Currently, I have to manually type in the table name each time.

8732 posts

ansgar posted 3 weeks ago

Did you notice there are some variables, just not for the table?

If you want one file per table, you may set

Output to "Directory - one file per object in database subdirectories"
and Directory to "C:\Backups\%y-%m-%d\"

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