Current MySQL Breaks Export, Import Database With Virtual (Generated) Columns
I have this database with a table that has 2 generated (virtual) columns. I exported my database using your built-in database manager. Then I imported the SQL using the same tool. Unfortunately, there's an error, and it said that values are not accepted for virtual columns. Upon checking this bug reports: (1) https://bugs.mysql.com/bug.php?id=79148 , it says there that the bug is already fix in higher version of MySQL.
Please update the available MySQL version, please.
What I did just to get around with the bug was to manually delete the exported virtual columns with their values in the exported SQL file.
And it's super, super hassle to manually remove those part.
Lynnell Emmanuel Neri
shared this idea
-
Mike Krupov commented
I also had a similar problem, but had to hire development specialists to solve it https://sirinsoftware.com/services/firmware_development/ Unfortunately, my experience was not enough to solve the problem on my own.