[Phpwebsite-developers] Fallout DB backup & recovery

[Randall W. <rh...@ma...>]

Happy developers who have had their phpWebSite/Fallout installations hosed:

After having the phpWebSite 8.1.1 => phpWebSite 8.2 upgrade hose my Fallout
development installation, I am preparing to write a module and additional
scripts to backup and recover and otherwise control the database.

Has anyone been thinking about how they would go about doing this or of any
specific operations they would like to see possible?

Required operations:
    backup - write the entire database/or only those tables with prefixed
with core->tbl_prefix to a .sql script.
    recover - read an uploaded .sql script and run it against the db
    fix - roll back a db to a previous state. <- lower priority

Technical Note:

The phpws 8.1.1 -> 8.2 upgrade renamed every fallout_ table to
phpws_fallout_. I had been successfully running 8.1.1, 8.2-RC-n, and Fallout
in the same DB without conflicts using the table_prefix mechanisms, but
rolling in 8.2-stable broke that.
-- 
Randall Wood
rh...@ma...