Soon I'll have to move a Drupal site that now is hosted on Mysql 4.0 to a host that has Mysql 4.1. If i just import the 4.0 database into the 4.1 enviroment what kind of errors could I get?

The thing is I compared "database.4.0.mysql" and "database.4.1.mysql" and except for the addition of "DEFAULT CHARACTER SET utf8;" after every CREATE TABLE there are no differences. Is that important? (Please don't bash me, I don't know squat about Mysql :p)

Thank you!

Comments

rouvas@drupal.org’s picture

always do DB related operation on a scrap DB (i.e. a DB that you wouldn'tmind corrupting).

Other than that, there doesn't seem to be anything much more involved. The only difference should be the charset convertions.

pwolanin’s picture

I've had charset problems when going from 4.0 to 4.1. I solved it by explicitly exporting via mysqldum as latin1 and then importing as utf8:

http://drupal.org/node/76486

---
Work: BioRAFT

cflorin’s picture

Thank you very much for your replies! It really helped!