Blog

This service www.mailinator.com allows you to have an instant mailbox for getting junk e-mail without entering your personal data.

Shell Concatenate & Compress (to from) tar -cvzf filepath/filename.tar.gz filename Extract multiple files (from to) tar -xvzf filename.tar.gz Copy files across systems(from to) scp user@from-server:path/file user@to-server:path/file Sort with count by column x cut -d " " -f 2 raw.file | sort | uniq -c | sort -nr > ordered_by_freq_file – References www.watsys.unh.edu/Darlene/TechToolsFiles/LammersUNIXDemo/UNIX_Intro.html

Install needed packages sudo apt-get install gcc sudo apt-get install linux-headers-$(uname -r) Create vmware tools package Use VMware window option VM -> Install VMware Tools to generate a virtual DVD-ROM with the package. Uncompress & Untar VMwareTools-x.x.x-xxxxx.tar.gz click the packge DVD-ROM and “extract to” Desktop the tar.gz file Run vmware-install.pl sudo Desktop/vmware-tools-distrib/vmware-install.pl

In essence in order to fully backup and restore a MySql database server, you just need to use two commands mysqldump and mysql. For a “small databases” scenario you can find at the end a simple script to send the backup by e-mail. In conjunction with crontab you can almost name it a backup policy. MySQL backup> mysqldump -u <user> -p <passwd> --all-databases > <backup file> MySQL restore> mysql -u <user> -p <passwd> < <backup file> mysql --execute "update mysql.user set host='old' where host='host';" Backup script example #!/bin/bash # This script runs nightly to back a MySQL database to a e-mail account DATE1=`date +%D` DATE2=`date +%Y%m%d%H%M` # The email address that receives backups ADDRESS="alias@domain" # Local temp directory BACKUPDIR="/tmp" # MySQL username and password MYSQLUSER="user" MYSQLPASS="pass" # MySQL database to backup (or --all-databases to backup everything) DATABASE="--all-databases" # Name of backup file FILENAME="mysql\_backup" # Change to the backup directory cd $BACKUPDIR # Dump the MySQL databases to a plaintext file mysqldump -u $MYSQLUSER -p $MYSQLPASS $DATABASE > $FILENAME\_$DATE2 # Package (tar) and compress (gzip) the plaintext MySQL dump tar czf $FILENAME\_$DATE2.tar.gz $FILENAME\_$DATE2 # Mail the resulting archive to our Gmail account date | mutt -s "$FILENAME ($DATE1)" -a $FILENAME\_$DATE2.tar.gz $ADDRESS thanks to Bruno Rodrigues

In order to import registry changes use this command on the following .reg file examples. regedit /S <reg file> Add/update key and value Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\ExampleKey] "StringValue"="example" Remove key (including all values) Windows Registry Editor Version 5.00 [-HKEY_CURRENT_USER\ExampleKeyToRemove] Remove value Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\ExampleKey] "ExampleStringValue"=-

Due to some sort of domain policies you might be unable to have toolbars on the XP taskbar. Create a batch file and add it to the startup scritps with the following text: regedit /S "<path>\hacktoolbar.reg" Create a .reg file hacktoolbar.reg: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoToolbarCustomize"=dword:00000000 "NoBandCustomize"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoToolbarsOnTaskbar"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoSaveSettings"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoActiveDesktop"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "ClassicShell"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoCloseDragDropBands"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] "NoMovingBands"=dword:00000000

If you “have” to use Windows, are able to install software but lack disk access cygwin is the answer to your prayers. Use the setup file everytime you want to install or add packages. Nice cygwin configuration Admin - cygrunsrv shutdown Archive - unzip Base - alternatives ash base-files base-passwd bash coreutils cygwin cygwin-doc diffutils editrights findutils gawk gdbm grep gzip libgdbm libgdbm-devel libgdbm3 libgdbm4 libncurses5 libncurses6 libncurses7 libncurses8 libreadline4 libreadline5 libreadline6 login man ncurses run sed tar termcap terminfo which zlib Database - libdb4.1 libdb4.2 libdb4.3 Devel - expat gettext ioperm libiconv mktemp pcre ruby Doc - cygwin-doc expat man texinfo Editors - joe Interpreters - expat gawk perl ruby Libs - crypt expat fontconfig freetype2 gettext ioperm libXft libXft1 libXft2 libbz2\_1 libcharset1 libfontconfig1 libfreetype26 libiconv2 libintl libintl1 libintl2 libintl3 libncurses5 libncurses6 libncurses7 libncurses8 libpcre0 libpopt0 libreadline6 ncurses openssl openssl097 tcltk termcap zlib Net - ncftp netcat openssh openssl openssl097 rsync Perl - perl Shells - ash bash chere rxvt System - chere ioperm man ping util-linux Text - expat groff less texinfo util-linux Utils - bzip2 chere cygutils e2fsprogs pcre util-linux Web - wget X11 - X-startup-scripts xorg-x11-base xorg-x11-bin xorg-x11-bin-dlls xorg-x11-bin-lndir xorg-x11-etc xorg-x11-f100 xorg-x11-fenc xorg-x11-fnts xorg-x11-libs-data xorg-x11-nest xorg-x11-xwin xterm **cygwin friendly shell** C:\cygwin\bin\rxvt.exe -fn "Lucida Console-11" -bg black -fg white -ls -st -sr -sl 1000 -C -e /usr/bin/bash --login

This is a cookbook for a SubVersion (aka svn) installation on debian and apache2 with LDAP integration authentication. Install subversion apt-get install subversion Configure subversion mkdir /var/lib/svn svnadmin create /var/lib/svn/repos chown www-data:www-data /var/lib/svn/repos/ -R Install Apache2 apt-get install apache2 Set apache2 modules apt-get install libapache-mod-ldap libapache-auth-ldap libapache2-svn If needed enable modules a2enmod ldap a2enmod auth_ldap Setup Apache2 website Create folder mkdir /var/www/svnwebsite Create website configuration file usually in /etc/apache2/sites-available ...

Consciousness about what is Web 2.0 has been growing. So, tutorials and explanations are showing up everywhere as a way to try and capture the value created by this phenomenon, with the collaboration of the Gartner Group check these interesting links: https://www.out-law.com/page-7183 https://news.zdnet.co.uk/business/0,39020645,39280643,00.htm Growing list of the web 2.0 Son’s (unordered, incomplete): wikipedia stumbleupon digg youtube.com del.icio.us gravatar flickr google maps technorati.com linkedin.com LINKS Intro to Web 2.0