[SOLVED] ActiveRecord::StatementInvalid: Mysql2::Error: The used command is not allowed with this MySQL version

hi there...


i just want to share about

direct execution with ActiveRecord on Rails 4

its use effectively to load huge data, so  you need to bypass some needless functions.

sometimes you need to load maybe via CSV or load by SQL, but i recommend to use Local Copy in postgress of load local infile in mysql 

here is the solution 

put localinfile option on database.yml

default: &default
  adapter: mysql2
  encoding: utf8
  pool: 5
  username: root
  password: root
  socket: /var/run/mysqld/mysqld.sock
  local_infile: true

refs:

SoF

Ruby

..show all:.

.

hi there...


i just want to share about

direct execution with ActiveRecord on Rails 4

its use effectively to load huge data, so  you need to bypass some needless functions.

sometimes you need to load maybe via CSV or load by SQL, but i recommend to use Local Copy in postgress of load local infile in mysql 

here is the solution 

put localinfile option on database.yml

default: &default
  adapter: mysql2
  encoding: utf8
  pool: 5
  username: root
  password: root
  socket: /var/run/mysqld/mysqld.sock
  local_infile: true

refs:

SoF

Ruby