From: Greg Willits <lists@...>
Date: 2011-02-20T09:11:55+09:00
Subject: Re: Work with MySQL database

Manny 777 wrote in post #982624:
> But now - I don't know, how to fast check that the MySQL database is
> installed ok - exist any command to terminal for this? Or any tutorial,
> how to check it?
>
> For PHP exist for manage of MySQL database PHPMyAdmin - exist something
> similar for Ror? I found rbDB, but it looks that the project is death...


For GUI management of MySQL I use Querious (www.araelium.com)

but for a quick test via Ruby GEM, I use the following little ruby test 
file:

#!/usr/bin/env ruby

require 'mysql'

db_name = "mysql"
sql     = Mysql.new("127.0.0.1", "root", "", "#{db_name}")
tables  = sql.query("show tables from #{db_name}")

table_names = []
tables.each do |table_specs|
  table_names << table_specs[0]
end

p table_names

-- gw

-- 
Posted via http://www.ruby-forum.com/.