Hey, I’m trying to restore a really old backup from 2017 using installer.php. It worked great back then but haven’t touched it for some time. I ran up a 22.04 with current php, mysql, apache, etc. (which is probably the issue and I have no idea what versions I was running on back in 2017). I did note that I was using Dup 1.2.16 and WP 4.7.5, but not the other stuff.
All seems fine until importing the database on step 2, where I get a 500 error.
In the Apache logs, I see this
PHP Fatal error: Uncaught mysqli_sql_exception: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value in /var/www/html/installer.php:2019
Stack trace:
#0 /var/www/html/installer.php(2019): mysqli_query()
#1 {main}\n thrown in /var/www/html/installer.php on line 2019, referer:
I tried commenting out line 2019, but it still 500’s and complains about line 2084 which looks like it’s counting rows before creating the db (my sql and php is comically bad, sorry).
I saw another post that had a similar issue and was directed to a newer version of installer.php – I couldn’t even get that, or the latest version to run.
Any help would be amazing – it’s a backup of a family tree site my dad made before he passed away, so a bit sentimental.
Thanks,
Andrew.
- This topic was modified 11 hours, 5 minutes ago by .