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 or Import Command in file for scripts / documentation ...How can I do this

urmel's profile image urmel posted 2 months ago in General Permalink

Hallo everyone

I tried to generate an Export SQL into a file, for two table out of a small database. It worked fine for my table Exort as well for Import. But my question is now, I saw the possibility to store these command (Screenshot on you Webside) in a file for further use ... but I wasn't able to find this position on my HeidiSQL to store or copy/past the Commands generated on HeidiSQL. I'm using Windows MariaDB 10.6.5 with HeidiSQL. Please can you clarify if this is already in my HeidiSQL (Version HeidiSQL 11.3.0.6295).

Thanks a lot for your assistance Urs

ansgar's profile image ansgar posted 2 months ago Permalink

Which screenshot was it? It's not clear to me what you mean with storing commands.

urmel's profile image urmel posted 2 months ago Permalink

good morning Ansgar

I thought that I have seen a screenshot on your Images side with the possibility to ...

It would be great, if you have the possibility for functions like EXPORT or IMPORT (in my case Tables or Database) if you can store such commands, just generated by HeidSQL, before executing.

This would nice and fine, then you are able such commands to re-use these generated command in scripts / batch for automation, documentation or other purpose. Like this mysqldump command:

C:\PROGRA~1\MARIAD~1.6\bin\mysqldump --user=XYZ --password=DB$UserPW$ -Y --dump-date --databases TestDB > C:\SAVE\maria-TestDB\DB-Export\TestDB_dump.sql BTW: Your generated and executed command is much nicer then this one, the output is for each record a line.

Is this already possible? Or have I overlooked this store / copy function on HeidiSQL.

Thanks a lot for your assistance Urs

ansgar's profile image ansgar posted 2 months ago Permalink

You probably mean this menu in the SQL export dialog?

Description

urmel's profile image urmel posted 2 months ago Permalink

Hello Ansgar

Yes, exactly ...this is it! On my version I couldn't see the "copy mysqldump command" :-(

2 attachment(s):
  • HeidiSQL_export_Screenshot-2022-03-19-201555
  • HeidiSQL_export_Screenshot-2022-03-19-201555
ansgar's profile image ansgar posted 2 months ago Permalink

That's a newer feature, and available in the latest builds. I recommend to update through Help > Check for updates.

urmel's profile image urmel posted 2 months ago Permalink

Hello Ansgar

Oh ... My system is completely isolated ...which Build is it to download? Thanks a lot for your recommendation

Have a great day Urs

ansgar's profile image ansgar posted 2 months ago Permalink

Just click the download-build button on the update check dialog:

Description

urmel's profile image urmel posted 2 months ago Permalink

Hello Ansgar

I have installed the HeidiSQL_11.3.0.6447_Setup MSI package. The selection : "copy mysqldump command" is now in. Fine. Great Thanks a lot for your assistance and help.

Last question ... for the INSERT into any other database is this "copy mysqldump command" command also there? Are all (probably most) such "copy mysql command" available? Sorry, I know this is a new user question ... with best regards Urs

ansgar's profile image ansgar posted 2 months ago Permalink

The above mentioned menu is the only place where HeidiSQL provides a mysqldump command.

Are you aware the export dialog itself does an SQL export?

urmel's profile image urmel posted 2 months ago Permalink

Hello Ansgar

I have noticed during my test the SQL export has been executed ...

Thanks a lot for your assitance You tip, as well hint solved my open question on HeidiSQL

best regards Urs

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.