Search This Blog

Kapil's Blog

Well, I’m a Senior Full Stack Ruby on Rails Developer having experience of over 10 years. I have technically rich hands-on developing applications in Ruby on Rails, ReactJS, React Native, Python, Jekyll and develop the APIs as well. I am an enthusiast with experience in JavaScript frameworks such as - angualr.js, react.js, backbone.js, ember.js, vue.js, and CSS3, Bootstrap, HTML5, HAML, Slim, Redis, Sidekiq, Social Media API’s, Payment Gateways Integration.

Get link
Facebook
X
Pinterest
Email
Other Apps

July 13, 2020

Heroku PG Import from .sql

heroku pg:psql < file.sql

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

MySQL - ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

Get link
Facebook
X
Pinterest
Email
Other Apps

ActiveRecord::StatementInvalid (Mysql2::Error: SELECT list is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by):

Get link
Facebook
X
Pinterest
Email
Other Apps

Post a Comment

Powered by Blogger

Theme images by Anna Williams

Kapil: Well, I’m a Senior Full Stack Ruby on Rails Developer having experience of over 12 years. I have technically rich hands-on developing applications in ReactJS, React Native, Ruby on Rails, Python, WordPress, Jekyll and develop the APIs as well for Mobile Applications Development. I am also having experience in developing ruby gems that are really needed and helpful for the ROR developers. I am an enthusiast with experience in JavaScript frameworks such as - angualr.js, react.js, backbone.js, ember.js, vue.js, and CSS3, Bootstrap, HTML5, HAML, Slim, Redis, Sidekiq, Social Media API’s, Payment Gateways Integration. I am familiar with Project Management Tools like Pivotal Tracker, Trello, Basecamp, Asana, etc. I am having expertise in databases like Postgres, MySql, MongoDB, SQLite. I am having experience with Deployment processes like git, Heroku, AWS EC2, AWS Elastic Beanstalk, Google Cloud, Digital Ocean, Linode, GoDaddy (Parallels Plesk), etc. I have good experience with Testing Tools like RSpec, Circle CI, Automation Testing. I also work with CRM, ERP, Redmine, Sharetribe, Shopify, SEO and it would be a pleasure for me to do work with you.

Visit profile

Heroku PG Import from .sql

Comments

Post a Comment

Popular Posts

MySQL - ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

ActiveRecord::StatementInvalid (Mysql2::Error: SELECT list is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by):