Creating Backup and Restore where the Executable path in vb.net

Question

it seems i have some difficulty here some of the questions in google is quite not suited for my problem.

my backup code:

mb.ExportToFile(" '" & Application.ExecutablePath & "'\backup.sql")

my restore code:

mb.ImportFromFile(" '" & Application.ExecutablePath & "'\backup.sql")

i want that my back up is always where my exe file or near. i think this is posible.

it says: "The given path's format is not supported."

Answer 1

The .ExecutablePath method returns the executable name also ... you need to use this one:

mb.ExportToFile(System.IO.Path.GetDirectoryName(Application.ExecutablePath) & "\backup.sql")