Passbolt Migration Database Backup does not contain latest passwords

Checklist
I have read intro post: About the Installation Issues category
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue

Old Passbolt CE instance:
AWS EC2 AMI Passbolt CE
[ami-0540253430a561106]
Passbolt v.4.0.0

New Passbolt CE instance:
AWS EC2 AMI Passbolt CE
[ami-00d3d5d9ae8804ef4]
Passbolt v.4.9.1

Issue:
The freshly created backup.sql created on the old instance does not contain recent passwords and seems to about 1 month old if imported to the new instance.

Steps taken:

I followed this guides for the migration

Alltough there is no dedicated guide for the AMI Instances on AWS so the following command was not working.

sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt mysql_export" www-data

returns:

Saving backup file: /var/lib/passbolt/tmp/cache/database/backup_1728382950.sql
sh: 1: cannot create /var/lib/passbolt/tmp/cache/database/backup_1728382950.sql: Permission denied
There was an error running the dump.
Please ensure on MySQL that the user has PROCESS privileges.
Database old_instance_db_name
User old_instance_db_user
Something went wrong!

So the command that worked was the following with user “admin”:

sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt mysql_export" admin

returns:

Saving backup file: /var/lib/passbolt/tmp/cache/database/backup_1728381696.sql
Success: the database was saved on file!

On the new Instance i tried to load the database with the command stated in the documentation

mysql -u new_instance_db_user -p new_instance_db_name < backup_1728381696.sql

returns:

ERROR at line 1: Unknown command '\-'.

So i tried to import it manually which worked but not all password seems to be imported or the backup file does not include recent passwords newer than 1 month

sudo mysql -u root
 mysql> USE new_instance_db_name;
mysql> SOURCE backup_1728381696.sql

Does the new db name contain hyphens?