Đang Thực Hiện

PHP script to import large XML file into MySQL

I am working on a new project based on open government data about motor vehicles.

I need help importing a huge (approx. 60 gbs) XML file into MySQL using php.

The file that needs importing is compressed and is 2 gbs in size.

(I will send you the link to the downloadable file that needs importing.)

Write a php script that will import the file into MySQL as it is too large to use the LOAD XML command.

Database name: sitedata

Table name: motor

I need to redo this import on a weekly basis so the script should start with a variable with the filename of the file to import like this:

<?php

//Variables

$file_to_import = '/home/data/import/20151011/[url removed, login to view]';

?>

I am running:

PHP Version [url removed, login to view]

MySQL [url removed, login to view]

Deliverables:

I expect you to provide the following:

1) A php script that will import the file.

2) The structure of the table that can contain the data

3) A compressed dump of the motor table in .[url removed, login to view] made using:

mysqldump sitedata motor | gzip > [url removed, login to view]

Kĩ năng: MySQL, PHP, XML

Xem nhiều hơn: help with php script, file expect, expect file, php script import csv file mysql, import xml file mysql using php, script import csv file mysql php, php script import xml mysql, import xml file mysql php, php mysql script import xml, script import xml mysql php ajax, php script upload import xls file mysql, upload import csv file mysql php script, free php script upload xml file mysql database

Về Bên Thuê:
( 0 nhận xét ) Rødovre, Denmark

ID dự án: #8682036

Được trao cho:

RobNL

Hello, I am Zend Certified Engineer from The Netherlands with over 9 years of experience. I can write the script you need and have it to you in just a few hours. Can you please provide the link to the file so I Thêm

$111 USD trong 3 ngày
(10 Đánh Giá)
3.9

15 freelancer đang chào giá trung bình $168 cho công việc này

KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Just reply with 'Yes' and We will come up with a. Detail project plan with our comments/queries. b. Best-feasible-real COST & TIMELINE Latest Projects : [login to view URL] Thêm

$250 USD trong 15 ngày
(623 Nhận xét)
8.4
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$206 USD trong 8 ngày
(373 Nhận xét)
8.1
codegur

We are pro and can write parser based on your xml that will insert the values into the database...if the xml strucuture is same it will work everytime without needed much modification within script. Write me back f Thêm

$211 USD trong 5 ngày
(230 Nhận xét)
7.5
dinhbang19

A proposal has not yet been provided

$111 USD trong 3 ngày
(134 Nhận xét)
7.2
gangabass

I'm expert in data processing with many years of experience that's why I'm sure you'll be impressed with my work. I can create such script for you in less than three days and I can offer you best price here. Actu Thêm

$155 USD trong 3 ngày
(265 Nhận xét)
6.8
BitLabs

Dear sir, I will complete your project within 3 days, LIFETIME error free guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "PHP script to import large XML file into MySQL" a Thêm

$150 USD trong 3 ngày
(112 Nhận xét)
6.6
speedev196

Hi dear. My name is JiaoMing. I am an expert in web develop such as PHP, AngularJS, IConic,Restful API, HTML, CSS, Jquery. I already checked your job. Your job is very interest. I would be happy to accept your requ Thêm

$147 USD trong 3 ngày
(56 Nhận xét)
5.9
CodeRaiser

Hello If you'd like it could be done in most efficient by RAM and time fashion. Even do several version and choose the one with best results. Don't forget depends on real data amount db may needs some optimizations Thêm

$155 USD trong 3 ngày
(35 Nhận xét)
4.8
sandeepv76

Hi, I am expert in PHP data automation process and I have already handled such large .xml schema processing and know how to hack on this. Just make sure target mySQL is on Server running on SSD Drives, I need sp Thêm

$250 USD trong 2 ngày
(28 Nhận xét)
4.8
suresh1986sl

Hi, I have good experience in PHP and MySQL. I have worked previously with such large files for an academic project which dealt with xml files related to input output data for all sectors for different nations. I can Thêm

$50 USD trong 1 ngày
(19 Nhận xét)
4.6
TauseefSatt1

Hy. I will make php script to import your xml file into mysql database. thansk..................................

$55 USD trong 1 ngày
(26 Nhận xét)
5.0
ravindraji

Dear Sir I am Ravindra Gehlot Senior Php developer of dreamsoft Solution .. We have 8+ year experince in Php and all CMS related to php like Joomla wordpress and other framwork like zend ,codeignitor , and cakephp, Thêm

$155 USD trong 3 ngày
(9 Nhận xét)
2.6
msnsoftware

By using latest technologies like XHTML, XML & CSS (CSS-based layouts instead table-based ones), we make sure that websites have valid & structured code to produce pages that will increase your target audiences and loo Thêm

$250 USD trong 4 ngày
(0 Nhận xét)
0.0
johamsit

Dear Sir, Thank you for your interest in working with Johams IT Solutions Pvt Ltd. Our team has reviewed your business requirements and has prepared the following detailed proposal. Given our experience and expertise Thêm

$263 USD trong 3 ngày
(0 Nhận xét)
0.0