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
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.

Post new comment

The content of this field is kept private and will not be shown publicly.