restore mysql database in vb .net

Question

i currently has an backup of a database (called ybam) in a sql script (called c:\20053131028.sql)... now i want to create a button where an user can restore the ybam database by click on restore button on the vb .net form.... what should i code in the button.... thank you very much....

mibuyt · Answer

Hi, Is it? Hmm.. then are you able to solve it yourself? If yes, how you do that? Cheers.

heeheelim · Answer

it do not restore the database.. anyway... thank you for your help...

mibuyt · Answer

This is the vb.net version. Imports System.Diagnostics Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point(80, 56) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 266) Me.Controls.Add(Me.Button1) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim process As New Process With process 'restore mysql database 'mysql -u sadmin -p pass21 Customers < custback.sql .StartInfo.FileName = "mysql.exe" .StartInfo.Arguments = "-u sadmin -p pass21 Customers < custback.sql" .StartInfo.WindowStyle = ProcessWindowStyle.Hidden .Start() End With End Sub End Class Cheers.

mibuyt · Answer

Ooops.. i forget this is vb.net section... i will convert it... sorry yeah :)

mibuyt · Answer

Hi, Look at this. using System; using System.Diagnostics; namespace WindowsListBox { public class MySql { public MySql() { } public static void Main() { Process proc = new Process(); // restore mysql database // mysql -u sadmin -p pass21 Customers < custback.sql proc.StartInfo.FileName = "mysql.exe"; proc.StartInfo.Arguments = "-u sadmin -p pass21 Customers < custback.sql"; proc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden; proc.Start(); } } } Hope to get you started. Cheers.

MythicalMe · Answer

This is a question better posed in the ADO.Net forum. I am unfamiliar with mySQL, but as it is very similar to MSSql my answer would be to create a stored procedure that does all of the dirty work for you and then use SQLCommand to execute the stored procedure. Alternatively, you can construct an SQLCommand as a string and execute that command too.

restore mysql database in vb .net

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)