Mysql backup

mysql Puerto Rico
  • 14 years ago

    Hi,

     

    I want to backup a mysql database through VB. I can think of something, but I need if somebody knows a way and can tell me I’ll be appreciated.

  • 14 years ago

    Never mind I found out how to doit.

    If some body need it.

    Backup:

    Shell("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump.exe" --user=user --password=password --host=localhost --databases DB1 DB2> "Path\File Name")

    Restore:

    Shell("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=user --password=password --host=localhost < "Path\File Name")

  • 14 years ago

    ARGHH.........

    I was wrong with the shell it doesn't work.

    How can I execute this like executing it from windows command prompt:

    """C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump.exe"" --user="

    & wContainer.Username & " --password=" & wContainer.Password & " --host=localhost --databases MySQL VideoDB > """ & SaveFileDialog1.FileName & """"

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Better train people and risk they leave – than do nothing and risk they stay.” - Anonymous