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: