Archives For mysql

The MySQL slow query log is one helpful tool that helps system administrators to determine which queries are taking a longer-than-normal time to run. The only thing is.. how to read it so it’s helpful?
Continue Reading…


When your server goes down hard, locked up or otherwise, you’ll sometimes find that you have some crashed tables. Why not fix them all in one swoop with one command from the cli?
Continue Reading…


Sometimes you’ll want to use the MySQL command line tool to drop a database..
Continue Reading…


You have a number of sites on your server.. how about an easy way to dump them all each night into a directory on the server!
Continue Reading…

Why use the command line when you can just use PHPMyAdmin or some other GUI tool? Because it’s faster, less chance for errors and you may need to anyway if your database size is larger than the upload limits in place by your server or GUI software.
Continue Reading…