Today I wanted to sftp into the webroot for my server (/var/www) but because of the way the permissions are set up the default ec2-user doesn’t have permission to do this. That directory tree is owned by the user “fred”, which otherwise doesn’t get used. I decided to allow ssh…
Fixing WordPress indexes, foreign keys and auto_increment fields
NB: this article is from 2017. While it is a useful guide, you should validate the process before using it. It may be inaccurate or incomplete as WordPress evolves. Comments in 2024 have indicated it still works, but use it at your own risk! I recently migrated a number of…
How to Migrate from RDS to MySQL on EC2
Introduction A year ago I moved all my websites to AWS using the free tier, using an EC2 t2.micro and the RDS relational database service. Now that my year of free tier is up I’d like to reduce my costs. I want to migrate from RDS to MySQL on EC2.…
Upgrade Running Nginx on Amazon Linux
If you’d like to upgrade running Nginx on your Unix server version read on for some information on how to achieve it.
Installing and Configuring PHP 5.6 on Amazon Linux
I’ve recently switched back from HHVM to PHP 5.6 because the version of HHVM I was using (3.6.6) keep hogging memory and failing to respond, and upgrading to a more recent version of HHVM is really difficult on Amazon Linux. PHP7 doesn’t work with one of my WordPress themes (Photocrati) so I can’t use that…