Since you were not getting error messages, it sounds like you were just having problems with PHP timeouts. In this case, the best solution to progress is just to reload and continue (like how you got from 27% to 94%). If you still cannot progress, then some file edits might be needed to tweak the size of some batches so they can finish before your PHP times out. This would vary depending on the step you stall on.
Unfortunately, the % or Step number is not useful to figuring out where you are stuck. Those numbers vary depending on the version you start at and your configuration. To review an upgrade issue, we need the version the upgrade says it's currently working on, the step number, and the step description, all from the progress dialog.
As you reverted both your database and file system, your wiki should be working in the same state as when those backups were taken. If it is not, you probably have some caches which you need to reset. Such as PHP opcache (by restarting PHP), or possibly a file-based datastore.
If the upgrade script is pointing to the production server and not the test server, possibly the test server's XenForo setting for the Board URL is still pointing to the production server.