[les1]

I'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this. Any help would be appreciated.

[cj777]

les1, on 17 March 2012 - 12:17 AM, said:

I'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this. Any help would be appreciated.

3rd year level BSIT TCA...

[DimitriV]

At a glance, this seems like it could be useful:
http://webcheatsheet...kup_restore.php
It uses the command line so it is really up to you to decide if you want to muck around with it.

[trevster344]

You could just write your own separate application to grab all the data from the database, and store it into a back up one whenever you want it, or in intervals.

[les1]

I found the solution.

Thanks for the replies

[nK0de]

Please be kind enough to share your solution here. It would help someone in the future who wants to do the same.

I'm new to MySQL myself. It would be useful to know how to do it without using commands.

This post has been edited by nK0de: 17 March 2012 - 10:25 AM

[trevster344]

I want to state for those who think Mysql and SQL are the same, they are not.

[les1]

nK0de, on 17 March 2012 - 10:24 AM, said:

Please be kind enough to share your solution here. It would help someone in the future who wants to do the same.

I'm new to MySQL myself. It would be useful to know how to do it without using commands.

Okay. To anyone who has the same problem here's the code

FOR BACKUP:

Process.Start("[PATH WHERE YOU CAN FIND THE MySQLdump.exe]", " -u [USERNAME] -p[YOUR PASSWORD] [DATABASE THAT YOU WANT TO BACKUP] -r ""[PATH WHERE YOU WANT TO SAVE YOUR BACKUP]""")

Example

Process.Start("C:\xampp\mysql\bin\mysqldump.exe", " -u root -pPASSWORD test -r ""C:\xampp\mysql\database backup\backup.sql""")

FOR RESTORE:

Dim myProcess As New Process()
            myProcess.StartInfo.FileName = "cmd.exe"
            myProcess.StartInfo.UseShellExecute = False
            myProcess.StartInfo.WorkingDirectory = "C:\xampp\mysql\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 [USERNAME] -p[YOUR PASSWORD] [DATABASE] < [PATH WHERE YOUR BACKUP LOCATED]")
            myStreamWriter.Close()
            myProcess.WaitForExit()
            myProcess.Close()

Example

Dim myProcess As New Process()
            myProcess.StartInfo.FileName = "cmd.exe"
            myProcess.StartInfo.UseShellExecute = False
            myProcess.StartInfo.WorkingDirectory = "C:\xampp\mysql\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 root -pPASSWORD test < C:\xampp\mysql\database backup\backup.sql")
            myStreamWriter.Close()
            myProcess.WaitForExit()
            myProcess.Close()

I hope it helps


I own nothing, I just found it by searching. Credit to original coder.

[nK0de]

Thanks.

[les1]

You're welcome