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 table same database

roger-u's profile image roger-u posted 3 weeks ago in General Permalink

Hi,

I recently exported a table to another database... with the typical setting to Truncate existing data.

BUT i maganged to forget to set the destination DB .. and it just happened to be the same as the source DB. so ... it duly truncated the table... lost all the data :( :(

Maybe the function should check that it is not exporting a table to itself!!

Roger

ansgar's profile image ansgar posted 3 weeks ago Permalink

I already fixed that last year, for the v10.3 release. Please update your HeidiSQL if there's a new release, to be sure not to run into old known bugs.

See also issue #775

Please login to leave a reply, or register at first.