-
Categories
-
Tags/Keywords
Ruby samba Debian xen zimbra WLB07051 SSH VIM RAID van der Molen Linux XTerm blog.bigsmoke.us WordPress RuG Firefox Subversion mod_rewrite X Apache postfix HTTP Gentoo Ubuntu DNS Windows plugin metabolism smb CSS T61 PHP bash CLI ssl svn MySQL nutrition Screen HTML WWW Family Javascript MediaWiki shell -
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 »