MySQL
Updated 13June2010
Runaway Process
I find it really annoying when my mysql processes run away. This doesn't happen very often so I can never remember the command.
Read more...Updated 29November2009
Reset MySQL Root Password
Have you forgotten your MySQL root password? I must admit I've been guilty of this a few times. Also helpful if you are working on a project where the previous developer or server admin has vanished. This article tells you how to reset your password.
Read more...Updated 24May2009
Back up and restore MySQL databases
I use MySQL on a daily basis. Most web developers connect to databases using GUI's such as phpmyadmin or MySQL query browser. This article will briefly explain how to use the command line to backup your databases, making it easy to automate your tasks using bash scripts.
Read more...
