mysql

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.

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: