Sample Header Ad - 728x90

How to take mysqldump with Generated column?

6 votes
4 answers
14936 views
I am getting below error while importing the dump, > ERROR 3105 (HY000) at line 82: The value specified for generated > column 'column_name' in table 'table_name' is not allowed. When I describe the table with error, there are some generated columns in it. > option_type | varchar(45) | YES | MUL | NULL | VIRTUAL > GENERATED What is the correct command to use when taking mysql dump for the database contains generated column? MySQL server source and destination version: > mysqld Ver 5.7.26 for Linux on x86_64 (MySQL Community Server (GPL)) MariaDB mysqldump CLI version: > mysqldump Ver 10.17 Distrib 10.3.12-MariaDB, for Linux (x86_64)
Asked by karthikeayan (193 rep)
Jun 19, 2019, 07:21 AM
Last activity: May 14, 2024, 11:50 AM