Topic: MySQL - default DB destroyed - recovery ?

[gieres]

Hi,

SME Server 8 as server AND gateway

Using PHPMyadmin, I have deleted by mistake the databases: HORDE and TEST.
I read on smeserver.fr that HORDE is associated with Webmail. But Webmail seems to work well.
There is no specific databases used on SMEServer, so, it is possible to reset all MYSQL during work processing.

Questions:
- is it dangerous ?
- how to restore these databases?
- using AFFA, is there a backup of these databases ?

I plan to reinstall SME with the "restore" function of the install CD. What do you think of this ?

Thanks for your comments.

[janet]

gieres

User preferences for webmail are stored in the mysql db.

it is possible to reset all MYSQL during work processing.
- is it dangerous ?

It will not kill you !

how to restore these databases?

Please read the mysql wiki article

using AFFA, is there a backup of these databases ?

Yes but depending which version of Affa you are using & the way you use Affa, there can be restore & other problems.

I plan to reinstall SME with the "restore" function of the install CD. What do you think of this ?

If you mean one of the default backup & restore functions then that is supported & safe to do.