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 bubuk.gabrok on
I did a mysqldump on svr-1 running mysql version 4.0x . Can I safely use that to create Drupal database on a different server (svr-2) running mysql version 4.1x ? Please advise.
Comments
re: Dumping mySQL 4.0 into 4.1
yeah, you can do that, but you may need to follow the permissions fix discussed here:
http://dev.mysql.com/doc/refman/4.1/en/mysql-fix-privilege-tables.html
I just did that last weekend and it went ok.
--You talk the talk, but do you waddle the waddle?
Great !
Thanks for the quick turnaround.
Beware the other direction! (4.1 to 4.0)
I don't have any experience of a the issues with Drupal and different mySQL versions, but I can tell you now that if you ever do a mysqldump from 4.1 and intend to use that data in 4.0 or lower (including 3.23) make sure you use the
--compatible=mysql40
or--compatible=mysql323
switches, or you could scramble your data. I believe it's something to do with converting UTF-8 to standard ASCII or something.