Re: [Phpwebsite-developers] Fallout DB backup & recovery

[Matthew M. <ma...@tu...>]

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

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

Yes, I was thinking about this. However once I created the full install
script, I backed off to work on other things.

There is a core function btw that installs a sql dump file. Look for it in
the setup portion of fallout. I want functionality to install modules
separately yet able to use the same backup code. I am also thinking of
trying to allow a check for updates at a location given by the
module/plugin developer.

> 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
>
> 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.

Ah I see. Still strange that it even bothered those tables at all?

Thanks Randall.

Matthew McNaney
Internet Systems Architect
Electronic Student Services
Email: ma...@tu...
URL: http://phpwebsite.appstate.edu
Phone: 828-262-6493