Dumping mySQL 4.0 into 4.1

By bubuk.gabrok on 15 May 2006 at 01:10 UTC

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

srlinuxx commented 15 May 2006 at 01:18

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 !

bubuk.gabrok commented 15 May 2006 at 01:31

Thanks for the quick turnaround.

Beware the other direction! (4.1 to 4.0)

Richard Sheppard@www.siliconmeadow.net commented 17 May 2006 at 18:15

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.