cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to move database to another server "#1293 - Incorrect table definition" on db import

Unable to move database to another server "#1293 - Incorrect table definition" on db import

We are getting "#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause " when trying to import the standard Magento 2 database to another server, using a stanard .sql database import via phpmyadmin, for deployment. Same error on 2 entirely separate hosting accounts. What's wrong with the standard table structure that this error is showing and how to fix? 

www.linkbrightmedia.com