the longblob is the biggest data type of Mysql. If I want to save something bigger than 4gb (longblob) how can I do?.
I'm talking about Mysql v-5.+
Using LONGBLOB can be very risky in light of the fact that the biggest max_allowed_packet is only 1GB.
Back in August 2006, someone asked a similar question. in which Peter Zaitsev said:
I am not a PostgreSQL DBA, but I would have to venture the following suggestion:
If you really want to store in mysql, then perhaps you could store it using chunks, meaning that you make an algorithm that takes your data and store it in the database in chunks - this ofcourse makes the programming a bit more difficult when retrieving the data, since you have to do the opposite, but this type of technique could solve your problem