Question: going from MySQL 4.1 back down to 4.0

Posted by bomarmonk on June 19, 2006 at 2:05pm

I copied my site to a test site in order to upgrade and enhance the site. Now I want to move from this test-site, running MySQL 4.1, back to my 4.0 MySQL hosted site. Will I run into any trouble doing this? With UTF-8? It seems like you should be able to go back down to 4.0, but I'm not sure. Any tips, advice, or words of caution would be appreciated.

Comments

It looks like I just need to dump into 4.0 compatibility

Posted by bomarmonk on June 19, 2006 at 2:45pm

I think I just need to select the option for a 4.0 compatible SQL dump (via phpMyAdmin). Sounds easy enough...

flag for mysqldump

Posted by pwolanin on June 19, 2006 at 3:41pm

There was another recent post address this issue, http://drupal.org/node/63582. The gist was similar- that there is a 4.0 compatibility flag that you should pass to the 4.1 version (or above) of mysqldump to insure that your data can be reloaded into 4.0.

---
Work: Acquia