Its a constant challenge to keep many of the systems that I help develop up to date with Government data sources. One of the most awkward is the LARS (Learning Aims Reference Service) database. () It’s updated several times a month, and is only available for download in .mdb, .csv and .psv files – none of which are even remotely useful for integrating with existing databases in a...
My site is being absolutely bombarded by page requests originating from semrush.com. Its a bot that is indexing and downloading links to my entire site, which would be fine if it were a small website, except that I have content going back to 1996, which is rather a lot, and they are hitting the server with so many requests that Apache2 and/or MySQL Server 5.7 is crashing. It’s utterly...
For PHP 5.6, to edit the php.ini file type:
sudo nano /etc/php/5.6/apache2/php.ini