Greetings!
I have been using the code below to restore backups of mysql database taken utilizing the mysql dump for a few years, but suddenly, this does not restore database backups anymore. Is there any change within mysql?
code:
Dim myProcess As New Process()
myProcess.StartInfo.FileName = "cmd.exe"
myProcess.StartInfo.UseShellExecute = False
myProcess.StartInfo.CreateNoWindow = True
myProcess.StartInfo.WorkingDirectory = "C:\Program Files\MySQL\MySQL Server 5.6\bin\"
myProcess.StartInfo.RedirectStandardInput = True
myProcess.StartInfo.RedirectStandardOutput = True
myProcess.Start()
Dim myStreamWriter As StreamWriter = myProcess.StandardInput
Dim mystreamreader As StreamReader = myProcess.StandardOutput
myStreamWriter.WriteLine("mysql -u " & dbuser & " -p" & dbpassword & " " & dbname & " < " & locationOfBackup & "")
myStreamWriter.Close()
myProcess.WaitForExit()
myProcess.Close()
Please note that the "& locationOfBackup" is a varialbe containing the location and the sql file name to be restore, no problem with this.
As I have pointed out, I have been able to restore backups with this until a few months ago. It now says backup restore was completed but there is actually nothing restored.
Server version: 5.6.22-log - MySQL Community Server (GPL)
Any help please?
Thanks!