14 February, 201411 December, 2017bash, Linux, Mysql Mysql SQL in bash one-liner If you just need a quick way to get some data from a mysql database in your shell (bash), you could do […]
31 October, 201314 February, 2014bash, Mysql, Wordpress Finding spam users We had a lot of spam users in our multisite wordpress system. This was because we had self-registration enabled for a period. […]
25 October, 20129 October, 2017Mail, Mysql, PHP, Wordpress Alert Blog Admin php script I had to send emails to all the Blog admins in our WordPress Multisite installation. This is how I did it: [code […]
11 June, 201211 December, 2017Database, Linux, Postgresql Postgresql 8.1 database bash dump script I’ve wrote a simple bash script to dump databases from a Postgresql 8.1 database server which uses the pg_dump and pg_dumpall. #!/bin/bash […]