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.

Set Rename Database from ALT+Enter to F2

JAB Creations's profile image JAB Creations posted 4 weeks ago in General Permalink

I looked through the Shortcuts in the Options though I could not find the setting for Edit Database which is currently set to ALT+Enter; how do I change it to F2?

ansgar's profile image ansgar posted 4 weeks ago Permalink

This "Edit" menu item is one of the few without an underlying "action", which means its shortcut cannot be customized. I guess this one is anyway used rarely.

JAB Creations's profile image JAB Creations posted 4 weeks ago Permalink

The reason I asked is because I do manual backups of all databases every so often. I wished there was an easy way where each database was saved as an SQL file (e.g. example_database was saved as example_database.sql) without having to save each database one-at-a-time.

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.
ansgar's profile image ansgar posted 4 weeks ago Permalink

You cannot create a database backup by renaming it or?

Backing up multiple databases into database filenames is easy:

Description

JAB Creations's profile image JAB Creations posted 4 weeks ago Permalink

Unfortunately that just made a single combined file called "%.sql".

JAB Creations's profile image JAB Creations posted 4 weeks ago Permalink

There is no edit option on the forums?

I meant to edit in: I do not want one gigantic merged SQL dump.

ansgar's profile image ansgar posted 4 weeks ago Permalink

No, you cannot edit forum posts.

You are sure you were using that %db filename pattern?

I just tested that, but Heidi just generates the filename with the first exported database, in my case I had test2 and test3 selected, which went both to test2.sql. So this looks like a bug.

JAB Creations's profile image JAB Creations posted 4 weeks ago Permalink

I tried [i]exactly[/i] what you said. The closest I can get with the available options is to create directories with a file for every single table.

To visually demonstrate what I need:

  • _prefix1_db1 ⇨ D:\path_prefix1_db1.sql
  • _prefix1_db2 ⇨ D:\path_prefix1_db2.sql
  • _prefix1_db3 ⇨ D:\path_prefix1_db3.sql
  • _prefix1_db4 ⇨ D:\path_prefix1_db4.sql
  • _prefix1_db5 ⇨ D:\path_prefix1_db5.sql
  • _prefix1_db6 ⇨ D:\path_prefix1_db6.sql

I just need a [i]single file per database[/i] saved when I export all of my customer databases in a single executive action. Is that currently possible or should I post a feature request? I appreciate your help!

ansgar's profile image ansgar posted 4 weeks ago Permalink

As written above, that db file pattern should do that. You can open a bug report for that, not a feature request. But please use the issue template.

JAB Creations's profile image JAB Creations posted 4 weeks ago Permalink

Posted: https://github.com/HeidiSQL/HeidiSQL/issues/1138

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




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.