Database list does not update with folder reading

[expired user #10958]'s profile image [expired user #10958] posted 7 years ago in General Permalink

Hi. Sorry for my bad english.

I usually transfer the database folders to the ./data/ folder between computers by restarting the MariaDB service and reopening the HeidiSQL. The databases are installed correctly in MariaDB, but HeidiSQL does not update the list of databases. Manually removing or changing the name is also not updated.

I found the \ HKEY_CURRENT_USER \ Software \ HeidiSQL \ Servers \ LocalMariaDB \ Databases in the Windows Registry, which contains the list of databases separated by ";", edited, restarted HeidiSQL and only then the list was updated.

I expected that, at least at startup, HeidiSQL would scan the data folder. Ideally, when pressing F5 this scan would be performed.

Grateful.

[expired user #1502]'s profile image [expired user #1502] posted 7 years ago Permalink

I believe that Heidi does NOT scan any folders to get a list of databases (it is just impossible for remote servers). It uses SQL commands SHOW DATABASES. You can see the command in Heidi's log (at the bottom).

In my case Heidi do this on startup or Refresh (F5).

If a databases list is not updated in you case you should manually execute SHOW DATABASES command and see results. For me it looks that something not right with you database movement process (I've never copied DB files only from one server to another as this process does not "sounds right" to me).

ansgar's profile image ansgar posted 7 years ago Permalink

Most probably you have given the session a list of databases in the "Database(s)" box. Just remove that and save the session, so it always scans for the whole database list automatically.

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