From: Junkone <junkone1@...>
Date: 2010-08-08T03:45:11+09:00
Subject: trouble with mysqldump

when i try
program="C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\
\mysqldump.exe"
irb(main):008:0> system(program)
Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]

it works and is able to launch myssqldump.exe
so i want to setup a backup process using ruby.
however the next step does not work. dont know why?

destination="e:\\tradingtools\\databackup\\#{dt}.sql"
system("#{program} --user=root --password=password dbtrader
>#{destination}")

error that i get is
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.