Some notes on transferring an existing WordPress site to Amazon Web Services and some common issues.
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.
Run the above command in SSH and follow the instructions, you will need to have the domain pointed and propagated for this to work.
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.