Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.5

Request #10892 Prepare for making rollback of an updated database
Submitted: 2007-04-30 10:02 UTC Modified: 2007-05-09 12:42 UTC
From: lsolesen Assigned: ifeghali
Status: Closed Package: MDB2_Schema (version 0.7.2)
PHP Version: 5.2.0 OS: n/a
Roadmaps: (Not assigned)    
Subscription  


 [2007-04-30 10:02 UTC] lsolesen (Lars Olesen)
Description: ------------ I want to be able to manage my database between versions using MDB2_Schema. The following scenario: 1) Version 1.0.0 is deployed and used for a week 2) Added a couple of features, added a field to the database and upgraded to 1.1.0 which is used for an entire day before I find a serious bug. 3) Now I have to revert to 1.0.0 while the bug is fixed, but a lot of data has been saved in the db - also in the new field. I want to keep those changes, as they should be available again when I upgrade to 1.1.1 (the bugfixed 1.1.0). All this should be achieved using the PEAR installer, so I need to know how to put the database definitions belonging to each version (so the next installer will know that). And it would be nice with some kind of safe way to upgrade and downgrade between versions. An automatic way to do this with MDB2_Schema would be nice?

Comments

 [2007-05-09 12:42 UTC] ifeghali (Igor Feghali)
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better. with the recent INSERT...SELECT addition it is now possible to save data before a table/field is lost and recover it back later.