[Phpvideopro-developers] Tools for export/import on database movement/update

[Peter B. <pb...@bi...>]

Hi,

because of a local Linux distro update (RHL 6.2 to 7.2) and therefore
a DB change from PG 6.5 to 7.1 I had to migrate the data from old DB
to new.

Looks like pg_dump'ed data in 6.5 cannot be restored in 7.1 therefore
I wrote 2 small Perl programs.

"dump_universal_phpVideoPro.pl" dumps a phpVideoPro DB in a "xml"
like scheme, currently only supported PG 6.5

"restore_universal_phpVideoPro.pl" restores the phpVideoPro DB from
"xml" like dump, currently only supported/tested PG 7.1.

Known bugs: the sequence ids must be set using "psql", the update via
the Perl program doesn't work (don't know why).


To Izzy: perhaps you add something like such "export/import from/to
universal format" so people can run backups and DB type moving
(PG<->MySQL,...) , too.

Hope this helps,

        Peter