Vb.Net Code For Mysql Database Back up and Restore when Click on the Button

Question

User1089220748 posted

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

Answer 1

User1500579645 posted

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

Answer 2

User-1274246664 posted

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.

Answer 3

User-1563925586 posted

This code may solve your problem

 Dim s As StreamWriter

Dim portfolioPath As String = My.Application.Info.DirectoryPath

If Not Directory.Exists("C:\Backup") Then

Directory.CreateDirectory("C:\Backup")

File.Create("C:\ Backup\PIS.Mdb").Close()

File.Create("C: \Backup\Backup log.rtf").Close()

s = New StreamWriter("C:\Backup\Backup log.rtf", True)

s.WriteLine("This backup was initially taken on - " & Date.Now)

                s.Flush()

                s.Close()

FileCopy(portfolioPath & "\PIS.mdb", "C:\Backup\PIS.Mdb")

s = New StreamWriter("C:\Backup\Backup log.rtf", True)

 MsgBox("New directory and backup file created")

Read more: http://ram-a-singh.blogspot.com/2011/12/how-to-take-backup-from-database-vbnet.html#ixzz1hLF6Cnd6