title: how to restore mysql backup that have generated always as column?
body: <pre><code>CREATE TABLE `revenue_daily` ( `wallet` varbinary(100) NOT NULL DEFAULT '0',
  `tc_access` varbinary(100) NOT NULL DEFAULT '0',
  `tc_short` varbinary(100) NOT NULL DEFAULT '0',
  `total_toll_collection` varbinary(100) GENERATED ALWAYS AS (`wallet` + `tc_access`) VIRTUAL NOT NULL,
  `cash_collection` varbinary(100) GENERATED ALWAYS AS (`total_toll_collection` - `tc_short`) VIRTUAL NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=ascii;
  </code></pre>
  
  <p>That table has generated column.I backed up database structure with data and when i am restoring same .sql file then error occur.
  Error is:-</p>
  
  <pre><code>ERROR 3105 (HY000) at line 262: The value specified for generated column 'total_toll_collection' in table 'revenue_daily' is not allowed. 
  </code></pre>
  
  <p>I am using mysql version:-</p>
  
  <pre><code>sunilp@sunilp ~&gt; mysql --version
  mysql: [Warning] World-writable config file '/etc/mysql/mysql.conf.d mysqld.cnf' is ignored.
  mysql  Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using  EditLine wrapper
  </code></pre>