Notes on Transferring a WordPress site to AWS

Some notes on transferring an existing WordPress site to Amazon Web Services and some common issues.

MySQL Import Fail

If the import fails on import pointing to an issue with the ‘comment_date’ field it’ll be a SQL setting that’s causing the bother.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

Add the above line to the top of your SQL import script.

Set-up an SSL

sudo /opt/bitnami/bncert-tool

Run the above command in SSH and follow the instructions, you will need to have the domain pointed and propagated for this to work.

Unable to Upload Files

Fix file upload permissions

sudo chown -R bitnami:daemon /opt/bitnami/apps/wordpress/htdocs/wp-content
sudo chmod -R g+w /opt/bitnami/apps/wordpress/htdocs/wp-content

After the above file uploads will be back to normal.

There is a bit more on the standard AWS Wordpress set-up here.