mysqldump on window xp problem

[jusan]

Hi, I am using mysql(odbc) with vb and ado on window xp. I would like to use mysqldump to backup my database. When I use mysqldump under Dos, it works fine. But when I shell out the command from vb program as follows,

cmdline="mysqldump --opt -u userid -pXXXXX database -c > /backupdir/backup.sql"
lProcID = Shell(cmdline, vbNormalFocus)

it dumps the whole database to the console not to the file.

I don't know why.

Another question: Can mysqldump to a floppy disk drive? Can it span several disks?

 

[QatQat]

- Take that '-c' off


- Yes it can dump to a floppy.


- No it can't span over different drives.


Bye


Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.

 

[jusan]

thanks.

I found out that under VB shell command won't work with redirect. When I use -r resultfile, it works fine now.