Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By cflorin on
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
As a general practice...
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.
I've had charset problems
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
Thank you very much for your
Thank you very much for your replies! It really helped!