Skip to content
Helge's blog
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx
  • bash
  • Linux
  • Mysql
  • Postgresql
  • Om oss
Search
Helge's blog
Close menu
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx
  • bash
  • Linux
  • Mysql
  • Postgresql
  • Om oss
Helge's blog
Search Toggle menu

Category: Database

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 […]

Posts pagination

< 1 2

Recent Posts

  • Stream Twitch in a WordPress post
  • WordPress can be used for online courses
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx

Recent Comments

  • Dana Costea on Use openssl to encrypt secrets
  • Trst on Apache reverse-proxy to Nginx
  • صيانة مولينكس on Connect to windows remote desktop from linux mint
  • Fernando Castillo on Connect to windows remote desktop from linux mint
  • صيانة براون on Connect to windows remote desktop from linux mint

Recent Comments

  • Dana Costea on Use openssl to encrypt secrets
  • Trst on Apache reverse-proxy to Nginx
  • صيانة مولينكس on Connect to windows remote desktop from linux mint
  • Fernando Castillo on Connect to windows remote desktop from linux mint
  • صيانة براون on Connect to windows remote desktop from linux mint
© 2025 Helge's blog. Proudly powered by Sydney