Joyce Babu

How to bulk remove uy7gdr5332rkmn malware using shell commands.

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.

Saving header and footer from a file into separate files using AWK.

Anyone who has worked with Linux must be familar with the wget utility. wget utility allows you to download files from a remote server using HTTP, HTTPS and FTP protocols. Downloading files using wget is as simple as wget http://www.joycebabu.com/my-photo.jpg Where http://www.joycebabu.com/my-photo.jpg is the file to be downloaded. By default wget saves the file with [...]

How to copy multiple files using the Secure Copy (scp) utility.

Update: I have written a  wrapper script for extracting single/multiple tables from a dumpfile. Now it is possible to extract tables with single command. Visit The other day, while working with the MySQL database of one of my sites, I accidentally damaged one of the tables irrecoverably. Fortunately, I was using AutoMySQLBackup script to backup [...]