Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts.
Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot be inadvertently changed by the other scripts. I currently add this back manually but I'd like to use php to do it.
I could change the data to txt or csv and use mysql insert statements but I cannot find how to do a simple upload the .sql to a db.
Where should I start looking?