Question: going from MySQL 4.1 back down to 4.0
bomarmonk - June 19, 2006 - 14:05
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.
It looks like I just need to dump into 4.0 compatibility
I think I just need to select the option for a 4.0 compatible SQL dump (via phpMyAdmin). Sounds easy enough...
flag for mysqldump
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.