MySQL 3.23.58+, max_join_size and a monster INSERT chain statement -help!

ppowell

		 $kommand = "mysql -t --max_join_size=" . 
					  (1000001 + @sizeof(@preg_split('/[\n\r]/', $archiveSQL)) + strlen(str_replace('"', '\\"', preg_replace('/[\n\r]+/', ' ', $archiveSQL))) + 1) .
					  " -h $dbHost --port=$dbPort -u $dbUser  " . 
					  " --password=$dbPwd -D $archiveDB -e \"" . str_replace('"', '\\"', preg_replace('/[\n\r]+/', ' ', $archiveSQL)) . '"';
		 $msg = exec("$kommand $redirect");

I am getting a rather obscure MySQL error (no error number, it only spits this back):

max_join_size 1072088

The SQL statement is an extremely large string of INSERT statements, anywhere between 27 and 500 or more, and I can't seem to get the INSERT statement to function, all the while continually producing this obscure error that does not have any documentation online that I could find.

I can't produce the actual SQL statement here, I'm sorry, the data is government-sensitive, not to mention extremely large in size!

Has anyone ever succesfully done an extremely large-sized multiple INSERT statement using MySQL command line before?

Thanx
Phil

ppowell

Ok, update.. I no longer get the max_join_size output, now I get this error, and it's even more bizarre:

ERROR 2005 at line 3: Unknown MySQL Server Host '/>\n','Madhu'

This comes from a very long INSERT statement that I honestly cannot reproduce here because of sensitive data that is used to generate the statement. However, the EXACT SAME statement is used by a PHP installer program I run outside of Apache that seems to have absolutely no problems doing the insert; when I run it within Apache using my web app tool, this error constantly appears, and I've never seen anything like it before.

Phil

ppowell

Another update:

Apparently I was mistaken, there is a major difference. The installer uses an actual PHP-based MySQL connection stream, whereas the web app tool uses a command-line MySQL reference for proficiency's sake (you're going to do several thousand INSERTs of data 70KB each at one time!)

Phil