Skip to content

Instantly share code, notes, and snippets.

@jonathanstegall
Last active July 29, 2021 18:10
Show Gist options
  • Select an option

  • Save jonathanstegall/fb8c6ef4a06d69a35a99ec3f2694389a to your computer and use it in GitHub Desktop.

Select an option

Save jonathanstegall/fb8c6ef4a06d69a35a99ec3f2694389a to your computer and use it in GitHub Desktop.
this is required for MySQL to successfully import a WordPress database on Mac OS, at least as of June 2020
set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET SQL_MODE='ALLOW_INVALID_DATES';
@jonathanstegall
Copy link
Copy Markdown
Author

It still is required, at least for me, as of July 2021.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment