Ticket #203 (assigned enhancement)

Opened 7 months ago

Last modified 7 months ago

Implement a backup/restore feature

Reported by: trac-user Assigned to: fox (accepted)
Priority: wishlist Milestone:
Component: database Version:
Keywords: backup restore dump Cc: emme@emmes-world.de

Description

Add a (maybe XML based) backup+restore feature, similar to the Mediawiki dumpBackup.php/importDump.php script.

This could be used to regularly backup the TTRSS database in a database-independent format, and to provide a migration path between different database backends.

Change History

04/23/08 13:47:10 changed by fox

  • status changed from new to assigned.

Accepted for "indefinite future" milestone.

04/29/08 01:09:13 changed by trac-user

I have extended the present script to do a full database import/export:

http://www.emmes-world.de/packages/ttrss-dump.tar.gz

I just tested the export from MySQL and the import into PostgreSQL, and my TTRSS survived without problems.

ttrss-export-dump.php exports the whole database including sequence numbers (emulated using MAX() for MySQL), and packs each row serialized and base64-encoded into one tag. ttrss-import-dump.php reads this, PURGES the existing data and reinserts the data read from the dump file.

Ciao

Martin Emrich <emme@emmes-world.de>