Download a Windows x86_64 MSI Package via mariadb.org.
Run the installer.
Optionally add some of the following to my.ini under mysqld section:
; Only listen on localhost bind-address=127.0.0.1
; Enable logging of queries ; (probably bad in production, but very helpful for development debugging) general-log=1 general-log-file=queries.log log-output=file
Restart the service, if you changed anything in the ini.
Check that it works by connecting with HeidiSQL or any other SQL client.
If you try to run for example SET time_zone = 'Europe/Oslo' on the default MySQL database that comes with WAMP you might get an error saying the time zone doesn’t exist.
Apparently this is because the time_zone tables for some reason are empty.
Working for a client who has documentation on a MediaWiki installation which was set up before we got there. Was able to create users for ourselves through the regular site, but certain things like deleting pages can only be done by sysops. None of our newly registered users are of course sysops and the only existing sysop user is from whoever installed the wiki to begin with.
Here’s how to promote a user to sysop the hackish way, directly in the database.
Find database details
Note: This can of course be skipped if you already know how to access your mediawiki database, but I didn’t 🙂
SSH into the system where MediaWiki is installed and find its location.
Was /var/www/html/foowiki in our case.
Open LocalSettings.php and everything should be under the heading ## Database settings
Promote user
Connect with a mysql client.
mysql -h localhost -u wikiuser -p wikidb
Find the user id.
SELECT user_id,CONVERT(user_name USING utf8)FROM`user`;
Here is a MySQL table containing continent names, country names and their ISO-3166 codes.
Needed one a while ago, but the ones I found were either kind of lacking or kind of old. So I made one myself by converting a datafile on Wikipedia into the format I wanted. Used some regular expressions and manual corrections. Later I also went through newsletters with Updates on ISO 3166. Hopefully I got it all right, and hopefully it can save you and others some time as well.
I have also subscribed to their updates and try to follow up when they change anything.
If you find any mistakes or updates I’ve missed, please let me know 🙂
Ever wanted to, for some reason, clone a database table? Don’t really want to export anything or figure out what statement was used to create that table? Turns out that’s a lot easier to do than I thought it was.