The correct order of restoring uploads?

The following should work as long as you didn’t change the hostname.

Enter the rails console:

cd '/var/discourse
./launcher enter app
rails c

Execute the following:

DB.exec("TRUNCATE TABLE optimized_images")
SiteIconManager.ensure_optimized!

User.where("uploaded_avatar_id IS NOT NULL").find_each do |user|
  Jobs.enqueue(:create_avatar_thumbnails, upload_id: user.uploaded_avatar_id)
end

DB.exec(<<~SQL)
  UPDATE posts
  SET baked_version = NULL
  WHERE id IN (SELECT post_id FROM post_uploads)
SQL

And then exit the rails console and execute a rake task:

exit

rake posts:rebake_uncooked_posts