I currently have 3 WordPress sites which I host on AWS Lightsail. I use the free version of the UpdraftPlus plugin to ensure they are all backed up on a regular basis (with backups automatically being pushed remotely to DropBox).
Data Pumper – Migrating Data from MySQL to PostgreSQL
I recently made the decision to migrate from MySQL to PostgreSQL (the reasons why to be covered later). I thought I’d just jot down my notes on a tool I tried which helped with the migration – SQL Workbench/J Data