Find Jobs
Hire Freelancers

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

$30-50 USD

Cancelled
Posted over 14 years ago

$30-50 USD

Paid on delivery
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 [login to view URL] 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 [login to view URL] 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
Project ID: 3023419

About the project

Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Weehawken, United States
5.0
25
Payment method verified
Member since Oct 14, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.