Upload file to blob in MySQL database

[dickhoning]

Hi there,

Does anybody have experience uploading a file to a blob in a MySQL database via the MySQL node in n8n?

Best regards, Dick

[MutedJam]

Hi @dickhoning, I am not currently using MySQL but in PostgreSQL this approach worked for me:

How to insert a binary file and query it in Postgres?

Hi @Jayavel, the exact approach will of course depend on how your incoming data looks like, but assuming you are having a binary item named data coming from your webhook something like below would let you insert a binary file into a bytea column. Table schema Table "public.uploads" Column | Type | Collation | Nullable | Default ------------+-----------------------------+-----------+----------+-----…

MySQL/Maria DB seem to offer similar functions TO_BASE64 and FROM_BASE64. Perhaps you want to give these a go?