jeffw Posted August 23, 2004 Posted August 23, 2004 Hi all; just wondering if somebody knows a script or way to list the MySQL server settings (similar to info.php for php). Specifically, I'm wondering about file insert sizes. I understand that there is a setting that can limit the size of a file used in the LOAD_FILE() MySQL function. For some reason, using the function returns NULL for the column value. The file is world readable and DOES exist (ie. can load it in a browser). The file in question is only 87KB INSERT INTO portfolio (image, thumbnail, title, description, category, materials, completed, posted) VALUES (LOAD_FILE('/home/xxxxx/public_html/temp/orig.jpg'), LOAD_FILE('/home/xxxxx/public_html/temp/thumb.jpg'), '', '', 'WoodCarving', '', '', CURDATE())Column 'image' cannot be null Any help appreciated... - Jeff W Quote
TCH-Bruce Posted August 23, 2004 Posted August 23, 2004 Welcome to the family, Jeff! The default limit is set to 2MB. Check out this help page. http://www.totalchoicehosting.com/help/phpmysqlpage.htm Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.