I have some codes in my application which makes a backup of mysql database and save the backup .sql file to a location on the hard disk. I made the code in like 2013/early 2014, I think I was then using a now older version of mysql, it worked perfectly.
But now, when I use this, it takes the backup as usual, no problem with the backup itself, the problem, when that code runs, it brings up a black command promp window which shows the used mysql user-name and the password used PLAINLY. After all the hard work I have done to ecrypt the password, this code simple prints out the real password and username just PLAINLY.
I am asking if anyone can suggest to me a better way of taking my backup and restoring them from VB.NET
I'm pasting the backup code here below, but please note that ALL the variables that you see have been well declared before being used and there is no problem with them at all. I decided to leave the declarations code away so as not to post a lengthy unneccessary code here. I'm posting the actual line where backup takes place, thanks.
Process.Start("" & dumpPath & "", " -u " & dbuser & " -p" & dbpassword & " " & dbname & " -r " & locationOfBackup & "")
**This uses the mysqldump to create backups/dumps, the variable "dumpPath" above is the location of the dump file in the host computer.
Thanks for any inputs.