Tuesday, March 19, 2013

Commands to Analyze, Check, Optimize and Repair MySQL tables

There are some useful table maintenance commands that every MySQL user should aware about. These are the most basic and effective commands. You can use these commands to check the consistency of all the tables. If your table becomes corrupt then these commands are helpful in recovery of corrupt table. So let's discuss each command one by one.

Sunday, March 17, 2013

MySQL back to basics: Commands for newbie users

Here is the list of most basic and useful commands for MySQL newbie user. These commands are used time and again.

Wednesday, March 6, 2013

Tips on securing MySQL database

Security of any database is very important and MySQL is no different. Here I am describing some basic security tips that every DBA should follow to protect MySQL database.