MySQL DUMP COMMAND in VB.NET

1

Good night guys I need to give this command in VB.NET SHELL but I can not do it already I tried 3 hours I read many things and I can not think outside the box.

Shell("CMD.exe /c cd \ & cd Program Files & cd MAPS & cd SERVER MANAGER & cd mysql & cd bin & mysqldump --user=root --password=x maps.controller > "C:\Program Files\MAPS\SERVER MANAGER\mysql\dumped.sql" ", AppWinStyle.Hide = 1)

It has a bug at the time of programming I have to think of something different but I can not get someone to have a light there, I already tried putting it via string naming STRING out and pulling in but at the time of the mysqldump command it needs to be read exactly like this in [DOS].

mysqldump --user=root --password=x maps.controller > "C:\Program Files\MAPS\SERVER MANAGER\mysql\dumped.sql"

In DOS this command is perfect within VB.NET that I can not seem to get.

In VB.NET CURRENTLY is this way to create; But create in a location that I do not want is the root folder of mysqldump.exe:

Private Sub BackupMAPSCONTROLLERDBToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles BackupMAPSCONTROLLERDBToolStripMenuItem.Click
    Dim ano, mes, dia As Integer
    Dim data_corrente As Date
    Dim data_corrente_saida As String

    data_corrente = dtp1.Value
    dia = data_corrente.Day
    mes = data_corrente.Month
    ano = data_corrente.Year
    data_corrente_saida = dia & "-" & mes & "-" & ano

    Shell("CMD.exe /c cd \ & cd Program Files & cd MAPS & cd SERVER MANAGER & cd mysql & cd bin & mysqldump --user=root --password=x maps.controller > " & "MAPS_CONTROLLER-" & data_corrente_saida & ".sql", AppWinStyle.Hide = 1)
End Sub
    
asked by anonymous 02.11.2018 / 22:05

0 answers