How 2 Guru

Today I am trying to restore one of MySQL dump into my development database.
While I executing the mysql -uroot -p XXXX < XXXX.sql, the restoration show me the error of ”ERROR 2006 (HY000) at line 3051: MySQL server has gone away“.

Then I double check on the database that I restore, I found that the action terminated in the middle & some of the tables & data is not restored.

I googled a while & found the solution.

read more »

As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it.

read more »

Some of website developers are need to track on visitor’s activity during browsing their website. Even would like to track when the visitor exit or quit their website.

Below is a simple example on how to using a javascript command to track on visitor exit/close page action.

read more »

Telnet mail server send email
Below is some instruction on how to testing your mail server using the telnet command. I found this is useful while you do some debugging on the mail server to send out email to others.

read more »

This post is to teaching a simple way on how to disable the select on the mozilla firefox. As I know, if you want to disable select in the Internet Explorer(IE), you may using the javascript onselect event to return a “FALSE”. This method will be only work for IE but not Firefox.

read more »