Categories
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 ;

Categories
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.

 

Categories
How to : Microsoft Windows

How to fix when music plays break-up at the end of the song in Windows Media Player

 

 

 

Categories
How to : Microsoft Windows

How to create a “New folder” in Windows 7 by using shortcut key?

Many people always ask me how to create a “New folder” by using keyboard, it is pretty simple and fast, and the magic key is :

Ctrl + Shift + N

Categories
How to : Microsoft Windows

How to rename a group of files or folders in Windows 7 by using shortcut key?

How to rename a file or a folder instantly by using keyboard, it is pretty simple,  select the file or folder you want to rename and the magic key is:

F2

So, how about a bunch of files or folders??

Select all the files or folders (shportcut key : Ctrl+A) as the following image :

Then, press F2, enter your new name, and you will get the result :

One more trick, if you want to rename the files or folders by certain ordering, what you have to do is before rename to the actual name you want to, you can rename them to a group of simple naming like “1, 2 , 3…” or “a, b, c…”. 😉

Categories
How to : Microsoft Windows

How to configure Internet Explorer to download more than two files at one time?”

By default, Windows Internet Explorer 7 and earlier versions limit the number of files that you can download at one time to two. Windows Internet Explorer 8 limits the number of files that you can download at one time to six. This change reflects the faster connection speeds that are now typical for most users. For dial-up connections, the limits from earlier versions still apply.

This article helps you increase the number of files that you can download at one time to 10.

For Internet Explorer 8.0

How to configure the connection limit by modifying a registry key

  1. Start Registry Editor.
  2. Locate the following key in the registry:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_MAXCONNECTIONSPERSERVER
  3. On the Edit menu, point to New, click DWORD Value, and then add the following registry values:
    Value name: iexplore.exe
    Value data: 10
    Base: Decimal

    Note set this value to the connection limit that you want for HTTP 1.1 connections. By setting the value to 10, you increase the connection limit to 10.

  4. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_MAXCONNECTIONSPER1_0SERVER
  5. On the Edit menu, point to New, click DWORD Value, and then add the following registry values:
    Value name: iexplore.exe
    Value data: 10
    Base: Decimal

    Note set this value to the connection limit that you want for HTTP 1.1 connections. By setting the value to 10, you increase the connection limit to 10.

  6. Exit Registry Editor.

Others IE Versions:

To increase the number of files that you can download at one time to 10, follow these steps:

  1. Start Registry Editor.
  2. Locate the following key in the registry:
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings
  3. On the Edit menu, point to New, click DWORD Value, and then add the following registry values:
    Value name: MaxConnectionsPer1_0Server
    Value data: 10
    Base: Decimal

    Value Name: MaxConnectionsPerServer
    Value data: 10
    Base: Decimal

  4. Exit Registry Editor.
Categories
How to : Windows

How to connect two computers?

Coming soon.

Categories
.NET How to : Microsoft Web Programming Windows

How to : Run classic ASP/ASP.NET on IIS 7

logo_dotNET

After installed IIS7, some people might find that classic ASP or even ASP.NET are not be able to run on the new IIS. Example test, http://localhost/test.asp or http://localhost/test.aspx

By default, the IIS is not configured for classic ASP (crab!), but do not worry, you just have to follow the simple 2 steps:

1) Go to Control Panel > Programs and Features > click Turn Windows features on and off

2) Navigate down the tree of features and make sure ASP is checked(checked ASP.NET if you want to run ASP.NET too). It should be under Internet Information Services (IIS) Manager > World Wide Web Services > Application Development Features. Press OK when done.

step1step2

p/s: There are many reasons to cause the classic ASP & ASP.net are not running well in local PC. Normally this solution is apply to those who installed the new IIS.