Skip to content

Instantly share code, notes, and snippets.

@clonn

clonn/solution.sh

Created March 6, 2022 07:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save clonn/0a38206a688246385d0df95bc89d1251 to your computer and use it in GitHub Desktop.
Save clonn/0a38206a688246385d0df95bc89d1251 to your computer and use it in GitHub Desktop.
Download ZIP
MacOS, Mysql, import [ERROR in query 44] Row size too large (> 8126). Changing some
Raw
solution.sh
# MacOS
$vim /usr/local/etc/my.cnf
# the content
###
innodb_strict_mode = 0
###
$brew services restart mariadb
@clonn
Copy link
Author

clonn commented Mar 6, 2022

Just make a short note, for next time i face the same problem again, and how to solve it.

ref
https://stackoverflow.com/questions/10757169/location-of-my-cnf-file-on-macos

https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te

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