Hi everybody!
Dotan Cohen wrote: > Is there a simple browser-based MySQL backup solution for > non-technical users. [[...]] > The main features needed are: > 1) Automatic scheduled off-site backups (via SSH or FTP) Off-site = good (for reliability purposes). > 2) Backup multiple databases and all their tables Definitely a "must have". > 3) Single-table recovery via GUI (the user simply chooses which > database and which table to recover) If your backup/recovery tool has this feature and your users ever go that route, you (your DBA / your authorities) must be aware that this will break any dependencies between that recovered table and all other, un-recovered ones. Example: Assume a new entry is added to the "customer" table, then (at least) one "order" is entered for this customer. Before, during, or after that, some garbage change is done to the "customer" table, it is detected, and someone decides "let's recover the customer table from the last good backup". This will get rid of the garbage, but will also make the orders for new customer be pointing to nowhere. IOW: As soon as you have relationships crossing table boundaries, a single-table recovery is a very risky operation, and it will violate any "referential integrity" constraints involving that table. > [[...]] Regards, Joerg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
