Keywords: LAMP/MAMP/WAMP - AWS - Technical issue - Upgrade
I tried to upgrade to the latest LAMP version on Lightsail for the first time. I followed the steps in this post: https://community.bitnami.com/t/upgrade-to-the-latest-php-or-the-latest-lamp-stack-within-the-lightsail-aws-service/57019
For the database backup I used:
mysqldump -A -u root -p > backup.sql
During the install, I selected all of the listed components.
For the database restore I used:
mysql -u root -p < backup.sql
Then I encountered this error:
ERROR 3554 (HY000) at line 3629: Access to system table 'mysql.innodb_index_stats' is rejected
For the following step, I had not found anything that had been changed prior to starting the installation. So I did not restore anything:
Migrate your php files and any configuration change you made from the old installation /opt/bitnami.back to the new one /opt/bitnami
When finished, I went to view the website. First off, I had an SSL error. It was time to renew Let's Encrypt anyway. So I used lego to request a certificate. That request reported that it completed successfully. But the SSL configuration still did not work.
Given the SSL problem, I viewed the site via plain http:// . That just showed me the Bitnami welcome screen.
The OP in the linked post referred to the need to upgrade the stack on an existing website. So I had the impression that the LAMP upgrade was going to leave the /htdocs files intact. I found that they were all gone. So I created a new Lightsail instance from a pre-upgrade snapshot to restore/recover.
Now I'm back where I started. What do I need to do to upgrade to the latest stack correctly and keep the website intact? Thanks.