Digital Your Life

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.

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 »

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

Moving file in PHP is quite easy. Instead you use rename function. It means rename can be used to move a file to it’s new location. For an example:

rename(‘/old_path/filename’,'/new_path/filename’);

Function rename return true when success and false when failed. Visit http://fr2.php.net/manual/en/function.rename.php for complete reference.

Someone in my office asked me to install dot net framework 3.5 and I said ok I will do that. I downloaded the “dot net framework 3.5” from Microsoft and started installation it was 6mb file so I thought it’s ok it won’t give any problem but when I started installation it said it need to download the rest of the setup and it will download some 60MB data.

Its not a good idea when you want to install dotnet framework 3.5 on many computers with slow internet connection. I started search on google search engine and find this link.

Read the rest of this entry »

I spent 80% of my worktime online and my favorite browser is Firefox. I recommend this browser to you because it has richest addons over the internet. You can find Firefox addon easily with custom function you need. And here are my Firefox addons:

lastpass is high secure online password reminder that help me to keep all passwords for emails, paypal, forums and may others. Your password is stored on secure server but encryption itself is done on your computer. Lastpass also can act as form filler.

firebug is essential to any one who does web design or programming, it is also a great tool for learning.  One of my favorite features is the ‘inspect element’ tool which allows you to see what tags and css are associated with a particular part of an html document.  With it you can also code css on the fly and see how it will affect layout.

Read the rest of this entry »

When you download Google Earth form http://earth.google.com it will download Google Earth Updater instead of Google Earth installer. Google Earth has now been included as part of Google Pack, which has Google Updater as one of its core program. There is a solution for people who need Google Earth but not require or like Google Updater to automatically install and update Google Earth for them.

The standalone Google Earth Installer located at:

Windows: Download Google Earth Offline Installer for Windows  (Freeware)
Mac: http://dl.google.com/earth/client/current/GoogleEarthMac.dmg