Having trouble transferring large databases to a managed database, as the mysql settings seem to be very strict and hard to work round, and when changing the mysql mode via the control panel it doesn’t seem to be reflected when trying to import, at least not straight away.
I have issues with ‘sql_require_primary_key’, which i understand there’s no work around for, as well as “zero dates” which the settings do not seem to effect.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.