Skip to content

Instantly share code, notes, and snippets.

@LuisErnestoZamb

LuisErnestoZamb/mysql restore limit

Last active July 27, 2016 18:23
Show Gist options
  • Save LuisErnestoZamb/8278e14d284607b2f06e90a0189f2584 to your computer and use it in GitHub Desktop.
Save LuisErnestoZamb/8278e14d284607b2f06e90a0189f2584 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql restore limit
[mysqld]
#bulk_insert_buffer_size=512M
# Allow external connections:
bind-address = 0.0.0.0
# only localhost
bind-address = 127.0.0.1
# or on mysql cli:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
# SET GLOBAL bulk_insert_buffer_size = 1024 * 1024 * 512;
SET GLOBAL max_allowed_packet=2*1024*1024*1024;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment