You're not serious are you? You don't really mean that you want a restore to be automatic do you?
I don't think I've ever met a DBA who would trust a fully-automatic restore: most DBAs want to have some control over the restore process so that they can at least *initiate* it when they want it. Otherwise, there is the risk that a restore will take place when they DON'T want a restore. Many DBAs would also want the option of choosing the restore point too. For instance, should the data be restored to the latest backup or possibly to an earlier backup if there is a chance that data corruption took place before the last backup. Restoring the wrong backup wouldn't be a good thing in that case. If you really do mean that you want to completely automate the restore, what event is going to trigger the restore? Rhino ----- Original Message ----- From: "PRATHIMA RAO" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Saturday, January 15, 2005 10:53 AM Subject: sqlyog hai, am using sqlyog for mysql i have taken back up in batch ie .sql i want to restore automatically can it be possible to restore by writing a code in vb using sqlyog i have written a programme in vb for taking back up automatically need help to restore the same automatically regards prathioma rao ---------------------------------------------------------------------------- ---- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]