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.

Select multiple elements when doing an export

Xenos's profile image Xenos posted 3 years ago in Feature discussion Permalink

When exporting a database, I sometimes need to export all tables of a specific pattern (here, the "mcl_*" tables; see picture).

This can be done by selecting these tables. But you cannot tick the checkboxes all at once: I must tick each checkbox, one by one. Hopefully, I can do that by selecting (highlighting) the table and pressing space (so selecting all "mcl_*" tables is like doing "[Space] [Arrow down] [Space] [Arrow down]..." as many times as required).

It would be better if you just allow to select multiple tables (or multiple elements in general), and then, pressing "space" would tick (or untick) all the checkboxes of the selected elements.

That way, exporting all "mcl_*" tables will be like "Select (highlight) all the tables then press Space. Done".

Thanks in advance (no matter whether it will be done, since it's not blocking)

1 attachment(s):
  • multiple-selections
ansgar's profile image ansgar posted 3 years ago Permalink

There is a way you probably did not know of: In the main window, on the "Database" tab, you can sort, filter and select tables per mouse. Then, rightclick the selected tables and click "Export database as SQL". Now the export dialog has the same items selected as you had in the main window.

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