After several months of down time, I have installed zenphoto-1.4.12 -- not an upgrade, but a fresh install. Previous version was < zenphoto-1.4.11.
There were a lot of other intervening issues,e.g., OS upgrade to FreeBSD v10.2. MySQL to v5.7.10 (now defaults to InnoDB), conversion from AT&T legacy ADSL to U-verse (static IP block), conversion from NetGear FVX538 router to Cisco RV016, ad nauseam.
Regardless, I have successfully restored all albums from backup; however, I don't know what to do with the DB table content. As I recall, the previous version of ZenPhoto installed on MyISAM tables. The fresh install created InnoDB style tables.
- What are the implications here?
- What are the differences in the table schemas?
- Is there a conversion-mapping system to accomplish such a task?
.
What to do???
Zenphoto
Comments
Zenphoto would work with both (and probably other engines, too). I don't think there is any conversion mapping necessary. All my installs use InnoDB and on most shared hosts you don't have a choice anyway.
Info about on the MySQL documentation:
http://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Or less technically the obvious wikipedia:
https://en.wikipedia.org/wiki/MyISAM
https://en.wikipedia.org/wiki/InnoDB