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.
Will export 20GB database cause a loss of application speed?
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.
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.
Please login to leave a reply, or register at first.