Re: [WebDNA] Upload file to mysql
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113474
interpreted = N
texte = 1069 --Apple-Mail=_4D9F2C78-AF99-434B-AAD8-3DFF94674C2A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Brian I have not done that, but providing your MySQL field is LONGBLOB all = should work.=20 Also to be able to insert images that are bigger than 1MB you have to = increase the max_allowed_packed option in the server configuration file. I use Navicat to write all my queries and then copy & paset the query = into my WebDNA doc. Navicat makes writing & debugging fast. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 21 Mar 2017, at 07:55, Brian Boegershausen
= wrote: >=20 > Anyone successfully upload a file to a mysql db? > I can upload a text file but that is it. > Jpg and gif fail. >=20 > Unbuntu 14 > Webdna 8.2 > Mysql 5.5 >=20 >=20 > Brian Boegershausen >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_4D9F2C78-AF99-434B-AAD8-3DFF94674C2A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Brian
I have not done that, but providing = your MySQL field is LONGBLOB all should work.
Also to be able to = insert images that are bigger than 1MB you have to increase the = max_allowed_packed option in the server configuration file.
I use Navicat to write = all my queries and then copy & paset the query into my WebDNA doc. = Navicat makes writing & debugging fast.
Kind regards
Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
Anyone successfully upload a file to a mysql db?
= I can upload a text file but that is it.
Jpg and gif fail.
Unbuntu 14
Webdna 8.2
Mysql 5.5
Brian Boegershausen
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail=_4D9F2C78-AF99-434B-AAD8-3DFF94674C2A-- .
Associated Messages, from the most recent to the oldest:
1069 --Apple-Mail=_4D9F2C78-AF99-434B-AAD8-3DFF94674C2A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Brian I have not done that, but providing your MySQL field is LONGBLOB all = should work.=20 Also to be able to insert images that are bigger than 1MB you have to = increase the max_allowed_packed option in the server configuration file. I use Navicat to write all my queries and then copy & paset the query = into my WebDNA doc. Navicat makes writing & debugging fast. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 21 Mar 2017, at 07:55, Brian Boegershausen = wrote: >=20 > Anyone successfully upload a file to a mysql db? > I can upload a text file but that is it. > Jpg and gif fail. >=20 > Unbuntu 14 > Webdna 8.2 > Mysql 5.5 >=20 >=20 > Brian Boegershausen >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_4D9F2C78-AF99-434B-AAD8-3DFF94674C2A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Brian
I have not done that, but providing = your MySQL field is LONGBLOB all should work.
Also to be able to = insert images that are bigger than 1MB you have to increase the = max_allowed_packed option in the server configuration file.
I use Navicat to write = all my queries and then copy & paset the query into my WebDNA doc. = Navicat makes writing & debugging fast.