Nevermind.. I found the problem. My production server is running mysql
3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a
"full table" condition. The new server is running 3.23, and once I removed the
SQL_BIG_TABLES=1 from the script (and allowed mysql to use memor
Hello - I'm posted this to the mysql list but got no response. While it sounds
like a mysql problem, I'm convinced that it is a PHP problem (see bottom of
note.)
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (fu
> If anyone is interested, this is what I finally came up with. I'm not sure
> how graceful it is, but it works ;)
Here's another method... which can be condensed, but I left it expanded to
demonstrate what was going on. The trick is finding the first day of the
*next* month, and getting the p