Upload File size in mysqld

[wdatkinson]

I need to increase the maximum upload size in mysqld from the default of 1Mb, to something like 10-16mb.

What I'm trying to figure out is how to do this with the DA installation. I've found a reference on mysql's website that refers to option files, but I'm not sure how to implement this on a DA server.

If an option file is not the best option I can also add:

--max_allowed_packet=16M

to the mysqld command line. Just want to make sure I do this in the right place.

[wdatkinson]

Fixed.

I created /etc/my.cnf, and added this:



[mysqld]
max_allowed_packet=16M


And restarted mysql.

I can now upload files to the database for my support program.

Anyone using SupportTrio will want to make note of this.

[drmike]

There's a fairly lengthly howto on this already here.

http://www.directadmin.com/forum/showthread.php?s=&threadid=132

You might want to consider adding the other options as well.

-drmike

[wdatkinson]

Thanks, I'll check that thread out as well.

I was surprised that I didn't have an /etc/my.cnf file anywhere on my system.

[jmstacey]

It's not created by default as DirectAdmin let's MySQL go to default settings.
However you can optimize it by simply creating the file and inserting anything you wish:

http://help.directadmin.com/item.php?id=44