Tuesday, March 24, 2009

facebook chat on pidgin

On Fedora:

yum install purple-facebookchat


and then set up an account like any other protocol.

Tuesday, March 17, 2009

Creating small samples of mysql dbs or tables

Table samples from a DB:

mysqldump --opt --where="true LIMIT 1000000" mydb > mydb1M.sql

Sample from 1 table:

mysqldump --opt --where="true LIMIT 1000000" mydb mytable > mydb_mytable_1M.sql


Source: http://www.ducea.com/2009/03/17/howto-get-a-small-sample-dataset-from-a-mysql-database-using-mysqldump/

Saturday, March 14, 2009

Maximize your Firefox display on your Eee PC screen

First things first, I've removed Fedora's top panel, and added everything I need from gnome on the bottom panel. I know it gives a more 'Windows' look and feel, but when you are on 9" or 10" screen running at 1024x600, there isn't much room for being pick.



As far as Firefox goes, here are a few things you can do:

1. Remove 'Status bar' and 'Bookmark Bar'. (Under 'View' on the main menu)
2. Install the Littlefox theme.
3. Customize your toolbars to 'Use small icons'
4. Install Fastdial add-on, that replaces the functionality of the 'Bookmark Bar' in case you are lazy like me.
5. Install Tiny Menu, once you do that, move all of the items from your 'Navigation Toolbar' to the Main Menu, and hide the 'Navigation Toolbar' under View.
6. Install Adblock Plus which will eliminate a lot of junk ads from websites, like cnn.com (see screenshot above).

Enjoy