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 1 year 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 1 year 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 11 months ago Permalink

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

ansgar's profile image ansgar posted 11 months ago Permalink

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

Description

Sven's profile image Sven posted 11 months ago Permalink

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

lotiara's profile image lotiara posted 3 months ago Permalink

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.




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.