Most of this information is posted already, but is specific to Apache (I am using IIS 5.0 with mySQL 5, AC0.7.1, mySQL administrator 1.2.12). Hopefully this will help out anybody who might experience the same problems that I had. I was receiving a mySQL Server has gone away error whenever I tried to upload a file larger than 1 MB.

I recommend downloading and installing mySQL administrator.

You will have several myxxx.ini files in the installed drive folder ..\Program Files\MySQL\MySQL Server 5.0. Depending on how you installed mySQL one of these will be used. If you are not sure or want to confirm which is used open mySQL administrator and go to Startup Variables - General Parameters. The Option File will be listed at the bottom of the page.

1. Open my.ini or the variant and add the following line to the [mysqld] section. 16M is arbitrary and should be equivalent to the largest file that you will allow to upload.

[mysqld]
max_allowed_packet=16M

2. You will then need to stop and restart the mySQL engine

3. Then also follow the steps as listed here : http://www.activecollab.com/support/index.php?pg=kb.page&id=17, changing the values of upload_max_filesize and post_max_size to equal the value set above.

4. Restart IIS (this reloads the php.ini values)