Em Andamento

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

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

Ver mais: get sql server port, problem statement, trying get, dbh, xml mysql use insert, server load log, sql cleanup script, php page load, php insert xml, sql code cleanup, simple management 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, project database management php, php attach, attach database sql server, simple php log, cleanup script sql, looking sql server

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

ID do Projeto: #3025262

Premiar a:

Monir1234

See private message.

$16 USD em 7 dias
(9 Avaliações)
2.5

10 freelancers estão ofertando em média $35 para este trabalho

dzmitrij

See private message.

$38.25 USD in 7 dias
(67 Comentários)
5.8
coderf1

See private message.

$34 USD in 7 dias
(68 Comentários)
5.1
setiawanutama

See private message.

$34 USD in 7 dias
(49 Comentários)
3.9
mayankashava

See private message.

$42.5 USD in 7 dias
(4 Comentários)
2.9
jack0stone

See private message.

$42.5 USD in 7 dias
(9 Comentários)
2.6
alienwebsl

See private message.

$38.25 USD in 7 dias
(6 Comentários)
2.7
binupn

See private message.

$38.25 USD in 7 dias
(0 Comentários)
0.0
sahilsmarrty

See private message.

$42.5 USD in 7 dias
(2 Comentários)
0.0
alisevw

See private message.

$25.5 USD in 7 dias
(0 Comentários)
0.0