Hi @gongomgra & @jota,
Okay got this transfer working now with the following bits to note.
Took quite a while as I wasted loads of time trying to connect to an RDS instance in another AWS account through VPC Peering but gave up as couldn't get a mysql connection from the server.
Anyway, created a MySQL 8.0.13 RDS Instance in my AWS Account in the same VPC as the EC2 instance running the Bitnami Stack.
Testing the connection and all worked fine, however.
I took a dump of the Bitnami Mysql DB with:
$ mysqldump -u root -p bitnami_magento > magento_db.sql
Then I stopped all services:
$ sudo /opt/bitnami/ctlscript.sh stop
I then logged into the RDS MySQL instance and created an empty database called bitnami_magento
Then I tried importing the magento_db.sql file into the RDS DB, however this failed with SUPER USER Privileges issues.
To get around this I had to do 2 things:
First thing I had to do was create a custom RDS MySQL8 Parameter Group with Log_bin_trust_function_creators set to 1.
I then had to modify the RDS Instance to use the new custom Parameter Group and wait for it to reboot.
Second thing I did was edit the magento_db.sql file and change all occurrences of:
Then using following it imported into the new DB fine:
$ mysql -h -u -p -D bitnami_magento < magento_db.sql
I then edited the apps/magento/htdocs/app/etc/env.php file with the new remote host, user and password information.
I then started all services, stopped mysql and removed mysql from the control process:
$ sudo /opt/bitnami/ctlscript.sh start
$ sudo /opt/bitnami/ctlscript.sh stop mysql
$ sudo mv /opt/bitnami/mysql/scripts/ctl.sh /opt/bitnami/mysql/scripts/ctl.sh.disabled
I then tested the default front-page and admin panel and could access everything fine.
So that's that process, couple of other issues that may be better placed to another topic but will ask here anyway.
One is removing the Bitnami corner banner where the docs mention just run:
$ sudo /opt/bitnami/apps/magento/bnconfig --disable_banner 1
However that directory only contains /opt/bitnami/apps/APPNAME/bnconfig.disable
Is there another way to do this?
Also, emails are not sending so will go looking at sorting that tomorrow.
Unfortunately didn't check if this was issue before the RDS move but will ask anyway if this more could effect why emails can't send and what I might check to get this working?
Thanks again for help.