No CLI allowed

[gmdavis]

So, I was trying to implement somehting reccomended in a previous post.

I want to use Command line interface to parse a huge file XML and put it into a MySQL database. I checked with my web host and they do not enable CLI fo rsecurity reasons. Of course my local testing/dev server has it enabled.

Would it make any sense for me to download the file to my local server, run the command line script and upload the parsed and ready MySQL database? If so, I don't have a clue how to teasfer data from the database of one server to another.

Forgive me if I sound like I don't have a clue. I am only just learning about CLI and MySQL so talk slowly.
😃

[drew010]

you should tell your host that cli php scripts cant do anything worse than a regular php script so there is no security concern with it. if its on linux the php binary should be able to run scripts from the command line. just php php -f script.php

[gmdavis]

just php php -f script.php

What does that mean? is this supposed to be formatted as code? Please elaborate.

[drew010]

to run a php script from the command line you would type
php -f script.php

that will run just the same in the browser as it would from command line.