Skip navigation links
5.1.9 Changes in MySQL 5.0.70 [MRU] (27 September 2008) »
Section Navigation      [Toggle]

5.1.8. Changes in MySQL 5.0.72 [MRU] (24 October 2008)

This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0.

Bugs fixed:

  • Incompatible Change: In connection with view creation, the server created arc directories inside database directories and maintained useless copies of .frm files there. Creation and renaming procedures of those copies as well as creation of arc directories has been discontinued.

    This change does cause a problem when downgrading to older server versions which manifests itself under these circumstances:

    1. Create a view v_orig in MySQL 5.0.72 or higher.

    2. Rename the view to v_new and then back to v_orig.

    3. Downgrade to an older 5.0.x server and run mysql_upgrade.

    4. Try to rename v_orig to v_new again. This operation fails.

    As a workaround to avoid this problem, use either of these approaches:

    • Dump your data using mysqldump before downgrading and reload the dump file after downgrading.

    • Instead of renaming a view after the downgrade, drop it and recreate it.

    The downgrade problem introduced by the fix for this bug has been addressed as Bug#40021. (Bug#17823)