<div>
You have to write script to unzip the csv and insert into Mysql... then you can make the script to cron.<br />
<br />
ref. <a href="https://www.experts-exchange.com/questions/23965839/PHP-Cron-exec-command-not-found.html" rel="ugc">https://www.experts-exchange.com/questions/23965839/PHP-Cron-exec-command-not-found.html</a>
</div>


You have to write script to unzip the csv and insert into Mysql... then you can make the script to cron.

ref. https://www.experts-exchange.com/questions/23965839/PHP-Cron-exec-command-not-found.html [https://www.experts-exchange.com/questions/23965839/PHP-Cron-exec-command-not-found.html]

<div>
Perfect. Even though my question wasn't clear. This was close to what I was looking for. Thanks.
</div>


Perfect. Even though my question wasn't clear. This was close to what I was looking for. Thanks.

<div>
Just make sure you get proper load data query ready and rest seems easy<br />
Write shell script::<br />
<br />
vi loadData.sh<br />
mysql -uUSER -pPASSWORD -e &quot;LOAD DATA LOCAL INFILE 'path/to/file.csv' INTO TABLE example FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES ;&quot;<br />
<br />
Crontab -e<br />
x x * * * sh /path/to/loadData.sh<br />
<br />
Below shall help::<br />
<a href="http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/" rel="ugc">http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/</a><br />
<a href="http://kedar.nitty-witty.com/blog/mysql-load-data-infile-syntax-generator-tool/" rel="ugc">http://kedar.nitty-witty.com/blog/mysql-load-data-infile-syntax-generator-tool/</a>
</div>


Just make sure you get proper load data query ready and rest seems easy
Write shell script::

vi loadData.sh
mysql -uUSER -pPASSWORD -e "LOAD DATA LOCAL INFILE 'path/to/file.csv' INTO TABLE example FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES ;"

Crontab -e
x x * * * sh /path/to/loadData.sh

Below shall help::
http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/ [http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/]
http://kedar.nitty-witty.com/blog/mysql-load-data-infile-syntax-generator-tool/ [http://kedar.nitty-witty.com/blog/mysql-load-data-infile-syntax-generator-tool/]

<div>
<div class="content wysiwyg-content">
I'm hoping somebody can help. I need to set up a cron to unzip csv fils and insert into mysql. The details aren't important just a good starting point would be great. I'm working with Linux Apache Red Hat. Thank you in advance.
</div>
</div>


I'm hoping somebody can help. I need to set up a cron to unzip csv fils and insert into mysql. The details aren't important just a good starting point would be great. I'm working with Linux Apache Red Hat. Thank you in advance.

cron unzip insert into mysql

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.