Monitoring Queries in MySQL in real time
Monitoring queries that are causing system bottlenecks is a common and extremely useful task. MySQL comes by default with the mysqladmin utility, which allows you to perform administrative tasks such…
MySQL: Recovering the root password
Accidents happen. Losing or forgetting a password is not uncommon. In this brief guide, we'll teach you how to change the MySQL root password on Linux servers. First of all,…
Posted inSQL
How to quickly back up MySQL in WAMP
Instead of dumping all the tables, as an alternative we can copy the necessary files from the MySQL "data" folder, and then restore these files in your new WAMP installation.…
Posted inSQL
Difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN
The SQL language allows tables to be joined, but sometimes these commands are forgotten and/or we get confused about the real purpose of each one. Let's take a look at…
