vb6 - MySQL database backup -

i developing project in vb6. in 1 menu named database backup, trying take database backup user interface (ie backup.frm form). in sql server tried & executed successfully, taking backup mysql critical me.

any solutions?

my sql server code

if trim(dbname) <> vbnullstring set odatabase = osqlserver.databases(dbname, trim(txtlogin)) set obackup = new sqldmo.backup  obackup.database = dbname                  '''set database name obackup.files = dir1.path & "\" & dbname & ".bak"       '''file path obackup.action = sqldmobackup_database     '''complete backup obackup.sqlbackup osqlserver               ''backup 

you're using sqldmo, sql data management objects, backup. library +specifically+ sql server, won't work else, mysql, oracle, whatever.

for mysql, you'll need lookup actual sql command used perform backup , invoke normal sql select, through connection object.

hmm, looked , doesn't mysql has kind of sql command that. looks have shell mysqldump.exe