A Bitnami alternative for AWS, image by image.

First-boot credentials

Moving a database

/opt/bitnami/mariadb/bin/mariadb-dump -h 127.0.0.1 -u root -p \
  --single-transaction --routines --triggers --databases <name> > db.sql

sed -i -e '/enable the sandbox mode/d' \
  -e 's/utf8mb4_uca1400_ai_ci/utf8mb4_0900_ai_ci/g' db.sql
mysql -u root -p < db.sql

The sed line strips the two things recent MariaDB dumps contain that MySQL 8 rejects. PostgreSQL goes across the same way:

/opt/bitnami/postgresql/bin/pg_dumpall -h 127.0.0.1 -U postgres > all.sql

sudo -u postgres psql < all.sql

pg_dumpall carries roles and their passwords across, including the postgres role. To copy plain files such as uploads, attach a snapshot of the old volume to the new instance and copy them off it.

Moving a WordPress site

1. 1. Snapshot the Bitnami instance. It is your rollback until the new site is live.

2. 2. Export from the Bitnami server. The first line prints the database name, user and password to use in the second.

   grep DB_ /opt/bitnami/wordpress/wp-config.php
   /opt/bitnami/mariadb/bin/mariadb-dump -h 127.0.0.1 \
     -u <DB_USER> -p <DB_NAME> > wordpress.sql
   sudo tar -czf wp-content.tgz -C /opt/bitnami/wordpress/wp-content .

   Older Bitnami images kept the site in /opt/bitnami/apps/wordpress/htdocs and the client in /opt/bitnami/mysql/bin.

3. 3. Import on the ProvenCloud server. Copy both files across as ubuntu, then:

   sed -i -e '/enable the sandbox mode/d' \
     -e 's/utf8mb4_uca1400_ai_ci/utf8mb4_0900_ai_ci/g' ~/wordpress.sql
   sudo tar -xzf ~/wp-content.tgz -C /var/www/html/wordpress/wp-content
   sudo chown -R www-data:www-data /var/www/html/wordpress/wp-content
   sudo wp --allow-root --path=/var/www/html/wordpress \
     db import ~/wordpress.sql

   Both sides default to the wp_ table prefix. If you changed yours, set $table_prefix in /var/www/html/wordpress/wp-config.php to match.

4. 4. Move the domain. Run sudo bash /home/ubuntu/iscripts/wp_url.sh to add your domain and make it the site address, point DNS at the new instance, then add HTTPS with sudo certbot --apache -d your.domain.