MAMP Migration

sudo apachectl stop

1. Convert ALL DateModified values to CURRENT_TIMESTAMP and NOT NULL
2. Update ALL system paths from htdocs -> Sites

PATH Updates:

Applications/MAMP/htdocs

Users/*username*/Sites

####

MySQL ZERO DATE issue:

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session;
SET sql_mode = '';
SET GLOBAL sql_mode = '';

MySQL GROUP BY ISSUE:

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','));

NOTE: Removed ‘ONLY_FULL_GROUP_BY,’ from the SQL MODE variable

https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc