Prev: Looking for good Ruby OpenSSL TLS docs
Next: Where + how to download Shoes
From: Junkone on 7 Aug 2010 14:41
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.
From: Jonathan Nielsen on 7 Aug 2010 14:59
[Note: parts of this message were removed to make it a legal post.]

On Sat, Aug 7, 2010 at 11:45 AM, Junkone <junkone1(a)gmail.com> wrote:

> 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.
>
>
You'll need to wrap the program name in quotes to use it with arguments like
that. Try instead:
system("\"#{program}\" --user=root --password=password dbtrader >
\"#{destination}\"")

Ideally you would pass each argument to system as a separate argument, like:
system(program,"--user=root","--password=password", etc)
But I don't know how to pipe the output of this to a file... perhaps someone
else on the list can help.

-Jonathan Nielsen

 | 
Pages: 1
Prev: Looking for good Ruby OpenSSL TLS docs
Next: Where + how to download Shoes