Moving MediaWiki to another machine

I've moved my MediaWiki from the faster and noisier machine to the slower but silent Mini-ITX machine. The wiki seems working with only minor formatting errors which was due to customized design. I should have store the customized images inside of the MediaWiki so that it will be easy to migrate to another server.

The only problem I had was moving MySQL databases. I've tried to use mysqldump to backup and restore the wiki database. However, whenever I tried to restore the database into the new server, it kept displaying either database not found error or permission error. Eventually I've used phpMyAdmin to move the database after I've changed the 1MB upload file size limit on PHP.

Tips on moving a MediaWiki

• Read this first: Manual:Moving a wiki
• Check upload_max_filesize, memory_limit and post_max_size in php.ini if you're moving large MySQL database using phpmyadmin.
• If you installed a extensions, make sure to copy the extension directory as well as any change made to LocalSetting.php.
• And of course, check MediaWiki, PHP and MySQL versions.