How to resize the image and convert to buffer then store to mysql using nodejs

Question

Because When I upload above 2mb size of image in node js using mysql

"not upload throw some issues"

"Got a packet bigger than 'max_allowed_packet' bytes"

I am using npm module multer for file upload. My code for upload image is as follows:

Possible duplicate of [MySQL Error 1153 - Got a packet bigger than 'max\_allowed\_packet' bytes](https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes) — adiga, Nov 22 '17 at 05:46
I would recommend you save your uploads as files rather than in your database. — jcaron, Nov 22 '17 at 07:44

Deep Kakkar · Answer 1 · 2017-11-22T06:44:09.823

0

You should modify in the my.ini or ~/.my.cnf file

max_allowed_packet=512M

You can insert this line under [mysqld] section.

After this change please Restart the mysql once. Thank you!

edited Nov 22 '17 at 06:44

answered Nov 22 '17 at 05:37

Deep Kakkar

5,831
4
39
75

Thanks bro . any changes in nodejs code ?.. because some restriction to use my.ini or ~/.my.cnf file in sql – Manimaran Nov 22 '17 at 05:56
In node js , are you using express ? – Deep Kakkar Nov 22 '17 at 06:08
now i changed but again show same error "Got a packet bigger than 'max_allowed_packet' bytes" . – Manimaran Nov 22 '17 at 06:43
you have to change .ini file OR one more if you can use streaming for upload the image. Can you share your code ? – Deep Kakkar Nov 22 '17 at 06:43
OK Deep. Thank you so much – Manimaran Nov 22 '17 at 06:46
are you using multer for upload ? – Deep Kakkar Nov 22 '17 at 06:52
you have only two options 1.) update .ini file 2.) use streaming module like express-busboy or busboy etc. to upload your file. It will upload your file in stream – Deep Kakkar Nov 22 '17 at 07:01
OK Deep. I will modified – Manimaran Nov 22 '17 at 07:06
Deep now i modified in the my.ini[max_allowed_packet=512M] file in my php myadmin. But again occur same error "a packet bigger than 'max_allowed_packet' bytes" – Manimaran Nov 22 '17 at 08:02
have you restarted mysql service after that? – Deep Kakkar Nov 22 '17 at 08:08
no. now i change my idea using "Sharp" Module and i try to resize image but still not resize – Manimaran Nov 27 '17 at 14:13
app.use(bodyParser.json({limit:'50mb'})); app.use(bodyParser.urlencoded({extended:true, limit:'50mb'})); – Deep Kakkar Nov 27 '17 at 14:15
https://stackoverflow.com/questions/32138748/pipe-a-uploaded-file-to-a-remote-server-with-node-ideally-with-same-filename – Deep Kakkar Nov 27 '17 at 14:25
Deep now i analyzing ! – Manimaran Nov 27 '17 at 14:40
ok, please share your answer or solution when ever you will get that. I also wants to know. – Deep Kakkar Nov 27 '17 at 14:41

How to resize the image and convert to buffer then store to mysql using nodejs

1 Answers1