I'm trying to move mac localhost Magento 2 DB and site to a live server using phpMyAdmin import. I've exported this DB to an .sql file. When I attempt to import I get this error:
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
How do I correct this?
OK, I killed that error, now I'm getting:
What the? Is there some export / import setting I'm missing? I've never had this much trouble importing a DB.
I don't want to have to restructure the local DB out of concern for crashing the whole thing. Any suggestions are appreciated.