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.

MYSQL 5.7 DUMP

michaelE's profile image michaelE posted 3 years ago in Import/Export Permalink

Related to the new possibility to add virtual columns in mysql 5.7 for JSON usage its cause bug during heidisql dump (in short the virtual columns must not be exported). this is was fixed with the classic mysqldump command for mysql > 5.7.9 versions.

michaelE's profile image michaelE posted 3 years ago Permalink

Please can you answer about this ?

ansgar's profile image ansgar posted 3 years ago Permalink

Well, yes, can confirm that issue - virtual columns are exported in HeidiSQL.

How does mysqldump exactly handle virtual columns? Data is probably left out, but the structure is required or?

michaelE's profile image michaelE posted 3 years ago Permalink

Thanks for you answer using mysqldump will of course export the structure but in the insert statment all the virtual columns will be ignored

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