Dumping MySQL Stored Procedures, Functions and Triggers

MySQL  has introduced some new interesting features, like stored procedures and triggers. I will show in this small post how we can backup and restore these components using mysqldump. What is Stored Procedure ? A stored procedure, by definition, is a segment of declarative SQL code which is stored in the database catalog and can … Read more

How can I stop a running MySQL query?

I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop the query. Hitting Ctrl+C (a couple of times) kills mysql completely and takes me back … Read more

http://www.msftncsi.com/ncsi.txt

What is www.msftncsi.com ? If you are running a firewall one of the most common sites you’ll run across is www.mstfncsi.com. This is because the url www.msftncsi.com is generally used by Windows machines to verity that there is network connectivity. A Windows machine (Windows 8, Windows 7 and even Windows Vista I believe) will try … Read more

TOP command in Linux

top provides an ongoing look at processor activity in real time. It displays a listing of the most CPU-intensive tasks on the system, and can provide an interactive interface for manipulating processes. It can sort the tasks by CPU usage, memory usage and runtime. can be better configured than the standard top from the procps suite. … Read more