Specified key was too long; max key length is 767 bytes

 https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes


run this query before your query:

SET @@global.innodb_large_prefix = 1;

this will increase limit to 3072 bytes.


# mysql -u root -p --default-character-set=utf8 databasename
mysql> SET names 'utf8'
mysql> SOURCE bkp.sql
-
Nhãn: ,

Không có nhận xét nào:

Đăng nhận xét

Đăng ký: Đăng Nhận xét (Atom)

Cold Turkey Blocker

 https://superuser.com/questions/1366153/how-to-get-rid-of-cold-turkey-website-blocker-get-around-the-block Very old question, but still wan...

  • poetry shell
      Basic usage | Documentation | Poetry - Python dependency management and packaging made easy (python-poetry.org) Activating the virtual env...
  • Modify File Permissions with chmod
      Modify File Permissions with chmod | Linode Modify File Permissions with chmod The chmod command allows users to change read and write per...
  • Python: poetry create poetry.lock from pyproject.toml
    Basic usage | Documentation | Poetry - Python dependency management and packaging made easy (python-poetry.org)   Python: poetry create poet...