Archives
-
Recent Comments
Category Archives: Just messing…
WordPress MU Upgrade and Permalinks 404 Erros
WordPress MU upgrade(from 2.x to 3.2.1) was a rather simple process surprisingly! Having completed it in a matter of couple hours for a fairly large blogging network, I was a happy camper up till the moment when permalinks started giving … Continue reading
Gnome Do, Docky, upgrade to Ubuntu 10.10 and an odd case of /var/lib/dpkg/tmp.ci/md5sums
So I finally upgraded to 10.10, a bit behind the curve but whatever. For the most part it went surprisingly swimmingly. I only had 2 issues First one – gnome-do docky theme was gone. And apprently it’s gone for good … Continue reading
How to move MySQL storage to RamFS or TmpFS partition
Whether moving all MySQL storage to a tmpfs helps with speeding it up or not is questionable but I needed to do for some testing purposes, so this is a short overview of how I did that hopefully will be … Continue reading
Posted in 4QuickLookUp, Just messing..., Linux/UNIX
Tagged mysql, performance, ramfs, tmpfs
2 Comments
TypePad to WordPress MU: Moving content with Technorati links, images, video and all that good stuff.
Getting content out of TypePad ain’t fun at fall. Getting content with images, technorati tags, videos is even more painful. With default TypePad ‘export’ feature you’ll just get partial content(some limited number of posts AFAIR), no technorati tags, no images. … Continue reading
Moving TypePad blogs to WordPress MU: TypeLists
TypePad suck, no two ways about it. Why, in your right mind, would you want to use something so limited in functionality on the platform that you have no control over, when there are tons of open source solutions that … Continue reading
Dump MySQL table or SELECT resultset into CSV or TSV file
Full table select: SELECT * INTO OUTFILE ‘/tmp/file.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ FROM `table`; Variations(for instance select from derived table): SELECT tbl.* INTO OUTFILE ‘/tmp/file.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY … Continue reading
Posted in Just messing...
Leave a comment
mysqdump procedures/functions only
mysqldump -Rdt -u username -p dbname > sqlfile.sql
Posted in Just messing...
Leave a comment
svn rollback
Sometimes I just wonder why there is no svn rollback… Well, this one should do it: svn merge -rHEAD:NNNN rep-url working-copy working-copy – path to your working copy. rep-url – URL or path to your repository NNNN – revision you … Continue reading
Installing AOLServer 4.5.0 + NsMySQL
Some errors that I’ve encountered while installing AOLServer with NsMysql module and our custom build module that uses NsMysql and Bstring libraries. 1. If make install gives you an error like this: aolserver-4.5.0 # make install ./util/nsmakeall.tcl install nsthread nsd … Continue reading
Posted in Just messing...
Leave a comment