How to Create the MySQL Database Backup Using ASP

[Muthu K]

Hi All!

I created a application using asp and mysql 4.1.1.
Now i face a new type of problem. that is
I can't create the database backup with asp code.
anybody known as plz help.
or send the code.

mycode :

set cnConn=server.CreateObject("ADODB.Connection")
cnconn.open(Application("cnStr"))
strBack="mysqldump -u myUid -p mypass mydb > myBack.sql"
cnConn.Execute(strBack)


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u myuid -p mypwd squarecrm > myBack.sql' at line 1
/crm/dbback.asp, line 14

plz help.

thanks in advance.


Muthu