From: Ad Ad <adityanerkar@...>
Date: 2009-02-16T23:16:02+09:00
Subject: Re: netssh and mysl

Hi,

the box on which mysql is staged accepts connections only from 
localhost. I couldn't get mysql to connect directly using the mysql gem.

But I did use netssh to send commands to mysql through ruby and get some 
results back.

ssh.exec("mysql -u username -ppasswd --batch -e \"select * from table\" 
schemaname > /tmp/mydata.txt")



which is good enough for now.

thanks for your input.
-- 
Posted via http://www.ruby-forum.com/.