PHP Page to Load XML page into MYSql fails on new SQL server, needs a little cleanup

I have a really simple PHP script which loads an XML file and then writes it to a mysql database. It uses mysqli_multi_query($dbh, $statement).

Script works fine on my one mysql server. I am looking to port this to a new machine that has a new mysql install. When running this script under this new mysql 5.1 it hangs. The old server was 5.0. I am not sure if that is my problem.

I get the error on the new server, 'mysql server has moved away' and the log file in the new mysql server fills up to 170+ megs

I messed around with all the buffer sizes and even took the [url removed, login to view] from the original mysql server.

php file is attached. I am thinking the solution is to modify this code so that it batches the inserts rather then trying to insert all 5000 lines in one shot.

If needed I can attach the [url removed, login to view] if somone thinks it is a mysql config issue but i did use winmerge to check the version on the old and new servers and it was almost exactly the same

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: statement problem, get sql server port, a problem statement, mysql 5.1, xml to my sql, i am trying to get this, dbh, xml mysql use insert, php modify php file, server load log, sql cleanup script, php page load, php insert xml, sql code cleanup, simple management php, php xml file use php, looking file management php, xml mysql php script, sql server database project, script xml file sql, xml page, little sql, php page moved, insert sql, attach database file sql server

Acerca do Empregador:
( 25 comentários ) Weehawken, United States

ID do Projeto: #3023345

2 freelancers estão ofertando em média $26 para esse trabalho


See private message.

$34 USD in 7 dias
(71 Comentários)

See private message.

$17 USD in 7 dias
(3 Comentários)