MySQL databases backup made simple

It's a bash program to backup all needed databases on my system. It uses thy MySQL database to get information what and when to backup. It is calling the mysqlbackup command so it's not very good for large databases.

Post is split this post in two parts: Installation in 4 steps and Description.

Installing two SSL Certificates on one server

Using one SSL certificate on the server is pretty easy, but what when we want to use SVN with apache and run the site which requires a payment system? Check if you do not have a second IP address before renting next server. Fortunately – Fasthosts give it for all servers.

Configuration happened to not be very complicated.

Moving Drupal from PHP4 MySQL4 and Apache 1 to newer versions

Recently I faced the problem of moving one of our drupal sites to a new environment. I had several problems, which probably are quite common. Here it is what one have to do – step by step.

My settings are (Drupal 4):

Old server: Apache 1.3, PHP 4.4.4, MySQL 4.1

New server: Apache 2.0, PHP 5.2.2, MySQL 5.0.40

1. Make a backup of the site (database and files)

Do full MySQL dump (preferable with DROP commands). It's easy to do with stuff like PHPMyAdmin. With a mysqldump command just do:

Installing a gentoo server without removable media


  1. Fixed a problem with chrooting into read only squashfs system
  2. Fixed a problem with resolving DNS names

I've rented recently a dedicated hosts. It's preinstalled OS was Fedora. I decided to install gentoo, as that's my preferred choice since few years now.

Because strange Orange policy – they are blocking Samba (Windows) shares to the outside world – I couldn't mount a Gentoo mini CD installation disk on the dedicated server.