Keywords: WordPress Multisite - AWS - Technical issue - Other
I have had my Bitnami AWS Ec2 instance hosting a Wordpress Multi-Site for a few years now. I would like to migrate my site to new Bitnami Ec2 instance in order to use the updated underlying software, for example newer PHP version and all the other changes that have happened over the years.
Firstly I want to state that I want to do this manually, I think this is better practice so please don't suggest severmask all-in-one migration plugin, firstly its very expensive and you have to renew it on a yearly basis. I don't believe that it is impossible for Bitnami to give us users some detailed steps to migrate manually please?
Firstly to make a backup of the htdocs folder is simple, that I have done.
The problem lays in making a backup of the database. I have followed this instruction https://docs.bitnami.com/bch/apps/wordpress/administration/backup-restore-mysql-mariadb/ and used this command mysqldump -u root -p bitnami_app > backup.sql after that it asks for a password. I managed to reset the password using this instruction https://docs.bitnami.com/aws-templates/apps/wordpress/administration/reset-password/ still after doing that and following the instructions carefully I get this error --> MySql ERROR 1045 .
Do I need to login to mysql when running the command to make a backup or is this in command line?
Are there simple step by step instructions how to make a backup of Wordpress Multisite and how to restore to a new server?
Also what user needs to do the backup, does this make a difference, I believe there could be some issue with user privileges, when I granted all privileges to the bitnami user my website went down and couldn't connect to database, luckily I made an image before and I restored.
I am now at a point where this backup of the database and then migrating it manually really seems impossible, I hope you can shed some light with some manual steps for me to follow to achieve this?