Notes on transferring a WordPress site to AWS

There's a newer version of this post: Bitnami WordPress: Reset file permissions on AWS Lightsail

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.

Ready to elevate your WordPress site?

Whether you're launching a new site, strengthening security, or integrating WooCommerce, I can help transform your vision into a high-performing online presence.

Contact me to discuss your WordPress project

More WordPress posts

Using WordPress as a static site generator

Static site generators have gained significant traction amongst developers, designers, and businesses seeking faster, more secure websites. Unlike traditional dynamic sites, which rely on a database to deliver content on…

Continue reading

Moving a WordPress Website with ACF and Custom Post Types to Brightspot CMS

Migrating a website from WordPress to Brightspot CMS can seem daunting, particularly when the WordPress installation relies heavily on Advanced Custom Fields and Custom Post Types. Both ACF amd CPT…

Continue reading

Better WordPress Performance

A slow-loading website can be frustrating, not only for your visitors, but for you as a business owner. If your WordPress site is taking too long to load, you’re not…

Continue reading

What's going on between WordPress and WP Engine?

The disagreement between WordPress and WP Engine has sparked considerable debate within the WordPress community and could have important implications for users of the WordPress content management system (CMS). WP…

Continue reading