Digital Your Life

[ad#Adsense 360x280]Backing up your database is a very important system administration task, and should generally be run from a cron job at scheduled intervals. We will use the mysqldump utility included with mysql to dump the contents of the database to a text file that can be easily re-imported. Read the rest of this entry »

[ad#Adsense 360x280]Sometime you want to know total disk consume by some table of MySQL database, you can do simple mysql query below:

SELECT table_schema, table_name, round(data_length/1024/1024,4)  FROM tables WHERE table_schema=’yourdatabasename’

The example above will tell you how many Megabytes consumed for any table found in database “yourdatabasename”, dont forget to substitute databasename with your own.

[ad#Adsense 360x280]The Routing table dictates where all packets go when they leave your system. On most environments, all packets that leave your system will be forwarded over to your router or hub, and from there out to the internet.

In some circumstances, you may have a testing network configured to duplicate another environment, or you may be configuring a more complex network topology that requires the use of additional routes. Adding routes to your machine is a useful testing tool for some of these situations. Read the rest of this entry »

[ad#Adsense 360x280]If you don’t change mysql configuration for history files then mysql by default stores the list of command used at the CLI (Command line interface) prompt in the file ~/.mysql_history

As a security precaution if the CLI is used to set passwords clear the history after using the CLI by deleting this file ~/.mysql_history

rm ~/.mysql_history

AddThis is the most popular website button allowing visitors to easily add your site to FaceBook, delicious, MySpace, your favorites, Live.com, Yahoo, Twitter and other social and bookmarking sites. On September 30, 2008, ClearSpring acquired AddThis. On October 8, 2008, ClearSpring began sending a ClearSpring Flash Tracking Object ( from http://bin.clearspring.com/at/v/1/svc6.swf ) to sites using the AddThis widget.

As with all flash tracking objects, the ClearSpring object uses Local Shared Objects aka “Flash Cookies” to track users as they visit multiple websites using AddThis or ClearSpring widgets. These cookies are not visible within user’s normal privacy options windows in their browsers and can not be cleared by using the browser’s Clear Private Data (Firefox) and similar privacy options. These cookies also work across all browsers on the machine as Flash stores these LSOs in a single location.

This change appears to have happened without any notification to the website owners who utilize the AddThis widget. The AddThis widget was previously quite unobtrusive and didn’t utilize Flash. To date, no notification has been sent to the users of the widget.

It is recommended that all AddThis users reconsider their use of the AddThis widget in light of its new privacy implications to your website visitors as well as AddThis/ClearSprings failure to notify you of this major change to their widget. I have removed AddThis from all of my websites.

Source: http://johnhaller.com/jh/useful_stuff/addthis_privacy_warning/

A few days ago twitter announced on their status blog that all twitter users are only allowed to follow maximum of 1000 people per day. This rule was designed to combat twitter spammer. The spammer usually following many users to get follow them back or just click their link to promoting something on the web. Popular tools to do this method is Humming Bird, that can follow and unfollow people by twitter automatically. This rule will decrease significantly for web marketters or at least make more difficult to increase their sales rapidly. Read the rest of this entry »

HidePost is wordpress plugin that allow you to hide entire or partial of your wordpress post to visitor. Only registered and logged in members can view any content hide between [hidepost] and [/hidepost] tag by default. I don’t know your reason to do this, may be you want to increase your blog members or just protect download link.

The advantage of this plugin is able to control different member level to view protected area by giving command [hidepost=level] Where level = 0 for registered member and 9 for administrator only. Read the rest of this entry »