Will export 20GB database cause a loss of application speed?

Hi Ansgar, we have to make a backup of our 20GB database. Will the export function in HeidiSQL cause a loss of application speed while creating the backup? Do you know how long it will take with attached settings? Thanks in advance.

You mean, the application may get slower after the export? Or during the export?

I'm just exporting three databases here as a test, summing up to roughly 20 GB, like yours. I see the export gets unnecessarily slow on certain tables, likely due to too large chunk processing. Apart from that, I have no issues.

My solution was to use commands in CMD to export and import the databases

Note the latest builds have a new feature for generating a mysqldump command line:

Alright, good to know for the next time :-)

Hi, The only reasom I have to use mysqldump command si because I want to export only a part of a very big DB and I don't know how to do it from Heidisql without bringing all the register to a view/sqlcommand. My question is how can I add views + procedures + triggers + events to mysqldump command (as Heidisql does) if possible ? Thank you.