Mostly Harmless

This post is an aide memoir more than anything else, but hopefully might come in handy to someone.

Settings.php

Database access details
Local file system path
URL (if changing)

Database

There are several instances within the settings table where the local file system path is stored within the database. Whether you pick find and replace (if restoring via a .sql file), the forum backend or PHPMyAdmin lots of things such as post icons and avatars will look screwy until you do. The theme path is also stored within the database in some instances. Make sure you get them all