I have a photo management system that I have build locally which uses mysql to store the images. the problem is that I exceed the max_allowed_packet value when my images are too large. I know how to set the max_allowed_packet value through the CLI with:
SET GLOBAL max_allowed_packet=16*1024*1024*1024;The problem is that when mysql is restarted or I reboot, this value is reset. Where can I make this change permanent?
Edit: BTW, I don't know if it makes a difference but I am on a mac.
Permanent settings are in Linux stored in /etc/mysql/my.cnf or /etc/my.cnf, depending on the distribution.
On a Mac you probably won't find the file and you'll have to create it. See http://forums.mysql.com/read.php?11,366143,376017#msg-376017
Permanent settings are in Linux stored in /etc/mysql/my.cnf or /etc/my.cnf, depending on the distribution.
On a Mac you probably won't find the file and you'll have to create it. See http://forums.mysql.com/read.php?11,366143,376017#msg-376017
Thx, I made the adjustments. We'll see what happens on my next upload.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.