Issue Command Line Instructions

chris_gilbert · #1 (**permalink**) 06-23-04, 05:32

Can anyone tell me how to issue command line instructions via ASP?

I am running a dynamic site using MySQL and ASP and wish to back up my MySQL DB on a daily or weekly basis to a remote server/MySQL DB. I know how to do this from the command line using MySQL:

mysqldump -u username -p password --databases myDatabase | mysql -u username -p password -h remote.server.com

But i need to be able to issue this command from within an ASP page.
PHP has various methods for executing command line queries such as exec() & shell_exec() but I don't know any using ASP.

Thanks in advance,

Chris

Seppuku · #2 (**permalink**) 06-23-04, 10:47

Code:

Dim objShell
Dim cmdString

cmdString = "mysqldump -u username -p password --databases myDatabase | mysql -u username -p password -h remote.server.com"

Set objShell = Server.CreateObject("WScript.Shell")
objShell.Exec(cmdString)
Set objShell = Nothing

Internet Services

Web Development

Digital Marketing

Consumer Tech