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.

Problems with Virtual columns when Exporting

ChrisCwmbran's profile image ChrisCwmbran posted 3 years ago in General Permalink

I'm using the latest build of MySQL to pass a database between two servers. In this case it happens one is on my local network and the other is remote, but I don't believe this to be relevant.

The problem happens whether I export directly from one server to another, or do it via an SQL file.

The issue seems to be that when SQL is exported, in the case of a virtual field, the definition of the virtual field is correctly exported, but in each line of the data the value of the calculated field is also included.

When I then try to import this SQL file onto another server the file fails to import because the server doesn't want to import values for the virtual field.

I've looked in the options, and I cannot see a way of changing this. Is this an unintended bug?

Thanks in advance,

Chris.

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.