I have done one POS application with Mysql Database via Creating DSN. I have a form with Two Button . One For Back uping Mysql Database (Dump Sql file)and another for restoring the database (Executing Batch file). I want the Simple VB.Net code for both Mysql Database Back up and Restore on the corresponding button click event with specfied directory path location and file name  to store with System Date. Please send me the full detailed codeunder the event

HI

http://www.codeproject.com/KB/dotnet/SQL_Server_backup.aspx

http://www.mssqltips.com/tip.asp?tip=1849&ctc

http://www.aspfree.com/c/a/VB.NET/Simple-BackupRestore-Utility-With-SQLDMO-Using-VBNET/4/

I hope this information will help you.

Venky

Why do you want to do this with in VB.net, you can write a procedure and pass in a parameter to either backup or restore. It would be much faster and  would be contained in  the database and called from you VB.net code.