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:
$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]
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]
15 freelancer đang chào giá trung bình $168 cho công việc này
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