How to : MySQL

How to get the size of MySQL Databases?

SELECT table_schema “ohmygoh”,
sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”,
sum( data_free )/ 1024 / 1024 “Free Space in MB”
FROM information_schema.TABLES
GROUP BY table_schema ;


Fastest way to remove all hyperlinks in Excel

The fastest way is you will need to create a macro to delete the hyperlinks in your Excel.

Step 1:  Create a new Macro. Go to View > Macros > Record Macro…

Step 2:  Enter a Macro name “removehyperlinks”.

 Step 3:  Edit Macro. Go to View > Macros > View Macros… And then click on Edit button.

 Step 4:  Insert/Paste fomular code into your  Macro as following figure:


After inserted the code, go back to the sheet of Microsoft Excel, Views > Macros > Stop recording…

 Step 5:  Run the Macro. Go to View > Macros > View Macros… And then click on Run button.




Screen Capture Utilities

  1. FastStone Capture : Shareware. FastStone Capture is a powerful, lightweight, yet full-featured screen capture tool that allows you to easily capture and annotate anything on the screen including windows, objects, menus, full screen, rectangular/freehand regions and even scrolling windows/web pages. You can choose to send captures to editor, file, clipboard, printer, email, Word/PowerPoint document or upload them to your website. Editing tools include annotating (texts, arrowed lines, highlights), resizing, cropping, sharpening, watermarking, applying edge effects and many more. It also allows you to record screen activities and sound into highly compressed video files. Other features include global hotkeys, automatic filename generation, support for external editors, a color picker, a screen magnifier and a screen ruler.
  2. PicPick : FREE. PicPick is user friendly and full of features for creating your image, suitable for software developers, graphic designers and home users.
    It is an all-in-one program that provides a full-featured screen capture tool, an intuitive image editor, a color picker, a color palette, a pixel-ruler, a protractor, a crosshair and even  a whiteboard.
  3. HyperSnap : Shareware. HyperSnap is the fastest and easiest way to take screen captures from Windows screen and full screen games, and text capture (TextSnap™) from places where normal text copy is not possible. HyperSnap combines the power of a first-class screen capture application with an advanced image editing utility – wrapped into one easy-to-use tool!

Synchronize data between PCs, Laptops, or thumbdrives

  1. Allway Sync : It uses innovative synchronization algorithms to synchronize your data between desktop PCs, laptops, USB drives, remote FTP/SFTP servers, different online data storages and more. Encrypted archives are supported. Allway Sync combines bulletproof reliability with extremely easy-to-use interface.

Clean Up Windows Utilities

  1. ShellExView v1.70– Shell Extensions Manager : Shell Extensions are in-process COM objects which extends the abilities of Windows operating system. Most shell extensions are automatically installed by the operating system, but there are also many other applications that install additional shell extension components. For example: If you install WinZip on your computer, you’ll see a special WinZip menu when you right-click on a Zip file. This menu is created by adding a shell extension to the system.The ShellExView utility displays the details of shell extensions installed on your computer, and allows you to easily disable and enable each shell extension.
  2. Driver Cleaner
  3. index.dat Cleaner
  4. system cleanup
  5. Eraser : Eraser is an advanced security tool for Windows which allows you to completely remove sensitive data from your hard drive by overwriting it several times with carefully selected patterns.
  6. Starter : Starter allows one to view and manage all the programs that are starting automatically whenever operating system is loading. It enumerates all the hidden registry entries, startup folders’ items and some of the initialization files, so that the user could choose to temporarily disable selected entries, edit them, create new, or delete them permanently.  Secondary purpose is to list all the running processes with possibility to view extended process’ information (such as used DLLs, memory usage, thread count, priorities etc.), and to terminate selected process.
How to : Windows

How to restore when hard disk corrupted?

When you are not able to restart your Windows, and most of the time is boot system files currupted, the “BEST” way to do is “Format“, but what about your data which not yet backeup?

Try below solutions before you format your hard disk (Windows XP installed):

  1. MBR : Insert Windows Installer CD > Press R to Recovery > Dos mode screen appear (Recovery Console), type “Fixmbr” after C:\Windows >Press Enter > Enter Y when warning message appear > Done.
    * MBR = Master Boot Record. 它是在硬碟的第0軌的一個記錄,其中包含了啟動電腦系統所需要的程式碼。
  2. NTLDR:  Insert Windows Installer CD > Press R to Recovery > Dos mode screen appear (Recovery Console), type “Fixboot” after C:\Windows >Press Enter > Enter Y when a notification message appear > Done.
    * If you able to logon to Windows, Right click My Computer >Properties >Advance > Startup & Recovery > Settings > Choose the system that you want to fix.
    * If you see “NTDLDR is missing.” message, normally this message appear when you hard disk installed more than one Windows, so it caused error when another Windows systems have been deleted or modified.



Font Viewer Utilities

  1. Font Viewer : Font Viewer renders all installed font families in a scrollable grid view, and allows you to change the size, color, background-color and displayed text, all at the touch of a button. Its built-in listing feature lets you select fonts and store their names in a readable and easily-accessible format.
    You can also export your list to a text file (.txt) or a FontViewer file (.fv) for use at a later date. Additionally, you can export your font list to an Adobe Acrobat PDF file (.pdf), with all of the styles and settings applied.
    Support UTF-8, like chinese font types.

極速提升Windows XP效能

極速提升Windows XP效能:

  1. 刪除華麗畫面:
    Start > My Computer > Right click Property >> Advance
  2. 加快選單顯示速度
    Start Menu
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_USER\Control Panel\Desktop >
    MenuShowDelay > Change 400 to 0
  3. 加快自動更新率
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Control\Update > Change 400 to 0
  4. 寬頻上網高速化
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters > Parameters > Change 400 to 0
  5. 縮短XP開關機時間
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Control\SessionManager\MemoryManagement\Prefetch Parameters>
  6. 定期磁碟重組

How to bypassing firewall or proxy restrictions

  1. Socks2http: Socks2http is a program that implements HTTP Tunneling.
  2. Hotspot Shield: Hide your IP address for your privacy online, Protect yourself from identity theft online, etc.
  3. PortTunnel
Microsoft Windows

[Solved] Show Desktop icon is missing in Windows XP/Vista/7

If your “Show desktop” icon is missing from Quick Launch toolbar, the solution is pretty simple, you can re-create the Show desktop icon by yourself, follow these steps:

     *To make sure the Show desktop icon is shown in the Quick Launch toolbar, you should enable the Show Quick Launch setting in Windows XP.*

  1. Launch Notepad application or Click Start,  click Run, type notepad in the Open box, and then click OK..
  2. Copy and paste the following text into the Notepad window:
  3. And then save the file to your desktop as “Show desktop.scf”.
    The Show desktop icon is created on your desktop.
  4. Click and then drag the Show desktop icon to your Quick Launch toolbar.
  5. Done.