How restore calendar of one user ?

[arnaud80]

I have mySQL dump of OX server, and i need to restore a calendar of one user.
Or all data of this user.

Thank you,
Arnaud.

[Martin Heiland]

Hi Arnoud,

you can restore the whole database schema, but not single items of the users data.

Greetings

[pro-ite]

Mysql select statement should help to get calendar data

Hi Arnoud,

wie had a similar problem and solved it. Each user has an unique id. If it's deleted calendar data to restore you should be able to get it out of the del table of calendar data. Similar to this you can extract the calendar data of the calendar tables. If you don't need an extraction of the participants (for each appointment one or more) or resources it's quite easy. Import it as ical file or / and of course sql inserts.

Greetings
Ursula (pro-ite)

[arnaud80]

Thank you, I try this.