ids to files is in egw_sqlfs
Yes, that does sound better. this way we could even restore single items
from the gui (if implemented)
But it is quite some work, and until finished, the backup/restore thing will
be broken, unless we do a own backup/restore app.
Files that are physicallky deleted are gone, no matter what we do.
(the file backup works, but fails if there is to much data.)
Files still remain the problem here.
13:23:10 +0100
The more I think of it …
I tend to like the “reverse” idea. This will give us a much better data
integrity:
-
Backup just provides the restore into some kind of tempdb or let’s
have a more fancy name like “time machine” db 
-
in “Admin” is a Restore menu. This let’s you choose the user and the
application
-
every application has to provide a restore class if the applications
should be restoreable
-
the application, e.g. calendar
-
reads the current existing entries for the user
-
reads the entries in “tempdb” for the user
-
takes a summary with that information and deletes the events which
do not exist in “tempdb” and updates the ones which exist in “tempdb”;
all steps will be done with native reads and updates of the application
Therefore we’ll smoothly integrate into things like contenthistory,
syncml, GroupDAV and etags…
For the category thing: we’ll also provide an “phpgwapi” restore class
which will handle this.
What do you think?
christian
jaytraxx schrieb:
You’re right. We’ll have to handle this more sophisticated.
Before I start:
app = the app to restore
id = the array of id’s to handle
egw_links:
delete/restore (simplified view)
where (link_app1 = app AND link_id1 = id) OR (link_app2 = app AND
link_id2 =
id)
files:
where is the id => file relation stored? I dont’ know much about that,
sorry.
egw_api_contenthistory:
we have sync_appname and sync_contentid here. no problem.
Prefs and Categories:
hm… could be handled as an “application”, but I don’t plan to include
that
in the first step.
Yeah, it seems to me that this is some work 
But I think it will be worth. It’s hard for an admin to keep in mind that
just a complete restore is possible.
The complete reverse scheme of this idea will be:
- backup module just provides the data somewhere (maybe in a temporary
db)
- every supported application has an own (and hopefully intelligent)
handler
for the restore of the provided data
christian
Leithoff, Klaus wrote:
If you restore say infolog, you must aways have a look at the sqlfs part
(and the link table and the history, and the categories and preferences
and
config, …)
I just think its not as easy as just select an app and/or an user and
work
that filter into the/an app_specific restore.
I assume it would be sort of more of an rewrite as it appears in your
first
post.
Von: “jaytraxx” christian@jaytraxx.de An:
egroupware-developers@lists.sourceforge.net Datum: Mon, 1 Feb
2010
02:41:55 -0800 (PST)
Leithoff, Klaus wrote:
a bit more complicated. What about the file stuff
huh? (what do you mean …)
View this message in context:
http://old.nabble.com/Database-restore-for-single-users-and-ap
plicat
ions-tp27401516s3741p27402284.html
Sent from the egroupware-developers mailing list archive at
Nabble.com.
The Planet: dedicated and managed hosting, cloud storage,
colocation
Stay online with enterprise data centers and the best network in the
business
Choose flexible plans and management services without long-term
contracts
Personal 24x7 support from experience hosting pros just a phone call
away.
http://p.sf.net/sfu/theplanet-com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-develope
rs
–
Stylite GmbH
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de
Geschäftsführer: Andre Keller, Gudrun Müller, Ralf Becker
Handelsregister Kaiserslautern HRB 30575
USt-ID: DE214280951
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the
business
Choose flexible plans and management services without long-term
contracts
Personal 24x7 support from experience hosting pros just a phone call
away.
http://p.sf.net/sfu/theplanet-com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-develope
rs
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the
business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Stylite GmbH
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de
Geschäftsführer: Andre Keller, Gudrun Müller, Ralf Becker
Handelsregister Kaiserslautern HRB 30575
USt-ID: DE214280951
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
