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.

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

Sven's profile image Sven posted 7 months ago in General Permalink

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.

1 attachment(s):
  • HeidiSQL
ansgar's profile image ansgar posted 7 months ago Permalink

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.

Sven's profile image Sven posted 1 month ago Permalink

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

ansgar's profile image ansgar posted 1 month ago Permalink

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

Description

Sven's profile image Sven posted 4 weeks ago Permalink

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

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.