-
Categories
-
Tags/Keywords
svn smb XTerm nutrition MySQL Firefox Javascript WordPress SSH CSS VIM van der Molen HTML PHP blog.bigsmoke.us Windows RuG WLB07051 WWW plugin samba bash Linux CLI HTTP metabolism Ubuntu ssl postfix X zimbra xen Subversion T61 Family RAID mod_rewrite DNS shell Debian Ruby Apache Screen MediaWiki Gentoo -
Recent Posts
-
Recent Comments
Tag: InnoDB
Trying to reduce MySQL InnoDB disk usage after major reduction of data
So, two days ago, I tried to shrink my MediaWiki database and it almost worked, except the MySQL process wouldn't shrink along with it.
Read More »
Converting all tables in MySQL DB to InnoDB
#!/bin/bash
exit 1
dbname="eorder"
echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t
echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t | mysql $dbname
Read More » MediaWiki problems with MySQL VARBINARY padding
I have been wanting to protect a certain page on my Dutch 15Monkeys wiki for weeks. I could install the ReCaptcha extension already (the best Captcha there is), but it's just that one page that's being spammed. So far, I've been unsuccessful in regaining my Sysop right for that wiki. I need these rights if I'm going to protect these pages. Read More »