Access existing MySql database with ruby (paths?)

Question

I have an existing mysql db used by a rails app. I want to create a Ruby script to run to perform a weekly maintenance task on the database. My first line is:
require 'mysql'
I have tried various 'paths' to point there but get an error message like:

1:in `require': no such file to load

I have:

code at: \ruby\sites\somepgm
mysql at: \ruby\lib\gems\1.8\gems\mysql-2.8.1-x86-mswin32

How do i get them to be nice to each other?

Answer 1

require 'rubygems'
require 'mysql'