Upgrading Drupal 4.6.5 to 5.7

Submitted by sugree on Tue, 02/05/2008 - 01:34

I just upgraded Rerng®IT with Drupal 4.6.5 and MySQL 4.1 to Drupal 5.7 and MySQL 5.0.32 on OpenFreeHost. The most classical problem is character set aka encoding. Drupal 4.6.5 still uses utf-8 on top of latin1 even though MySQL 4.1 supports utf-8. However, Drupal 5.7 will uses utf-8 on utf-8 natively if MySQL is 4.1 or later. So what is the best practice to upgrade Drupal through 3 major versions?

What I did are:

  1. Export old data using mysqldump

        mysqldump --add-drop-table -uusername -ppassword -c --default-character-set=binary database > backup.sql
 

  2. Import data to new server

        mysql -uusername -ppassword database < backup.sql
 

  3. Upgrade to Drupal 4.7.11

  4. Upgrade to Drupal 5.7
Roti (alpha) thinks you may like these:
  • (no links yet)
by Gabriel Radic (not verified) on Sat, 03/15/2008 - 05:02 #117

Hi,

I think I have the same issue you do. Did your method work?

by sugree on Sat, 03/15/2008 - 09:20 #118

It works perfect no problem at all. I just redo that method on another site last night. Successfully upgraded to Drupal 6.1.