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… Continue reading Extract single/multiple tables from MySQL dumpfile
Tag: MySQL
View currently running MySQL queries in realtime
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.