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 v8.0 support

russromei's profile image russromei posted 2 months ago in General Permalink

I'm using a new database version mysql v8.0 and thee seems to be a problem I run a select (returns > 10,000 rows) goto Tools>Export grid rows>Copy to clipboard>Excel CSV I paste into excel and only some arbitrary number of rows land (ie 40 of 10,756, 20 of 14,470) Has only been a problem since I moved to mysql v8.0

ansgar's profile image ansgar posted 2 months ago Permalink

Are you sure you did not select to export selected rows only?

russromei's profile image russromei posted 2 months ago Permalink

Yes, I'm sure It is only happening with certain account Ids (older ones) It's like the data is corrupt Everything seems to be working on the front end I tried export to file, same result Did a check and repair, no errors which is expected No problem until mysql v8.0

russromei's profile image russromei posted 2 months ago Permalink

phpmyadmin selects 10,762 HeidiSQl selects 10,762

Just a pasted error for these 2 accounts

russromei's profile image russromei posted 2 months ago Permalink

Update to 12.3 All works now

ansgar's profile image ansgar posted 2 months ago Permalink

Ah you were using an older release. Which one was it, with the bug?

russromei's profile image russromei posted 2 months ago Permalink

11.xx I think

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.