Joyce Babu

An year back I posted on how to extract a single table from a MySQL dump file. Today, I decided to write a shell script to automate the whole process. Now it is possible to extract a single table or a range of tables from a dump file with a single command. Usage The script [...]

Sometimes you might want to view MySQL queries as and when they are being executed. This is possible with the MySQL General Query Log. In this post, I try to explain how to use query logging feature to view live running MySQL queries.