Board Thread:General Discussion/@comment-1260239-20170204214052/@comment-26143371-20170211214627

Alternatively you could always set up a server for yourself and then use the method suggested by TyA. Because of wikia's customized installation importing the database directly might be impossible anyway, even for staff.

I definitely can't guide you through the process in detail, but here are some links that can get you started:
 * Use a hypervisor like Virtualbox to setup a virtual machine on your computer.
 * Install Debian or another linux distribution on it
 * Setup something like LaMp on it, which should mostly fullfill the reuqirements for MediaWiki
 * Import your database dump there and install MediaWiki (ideally the same version that was used on your previous server)
 * Export the XML dump with the method suggested above.
 * Import the result to wikia through Special:Import

That approach definitely won't give you any images that you had in the old installation. But since the database dump has only 3MB, you either don't have many images or MediaWiki doesn't store them in the database (I have no idea if it does). In the first case you can upload them by hand (Special:MultipleUpload might help), in the second case you won't get them from a database import either.

One more thing: Use Snapshots and use them often! You most definitely will screw things up at some point and snapshots will allow you to go back to a state where things were still OK.