MySQL

[Marcin Tyman]

Hi,
How to operate on MySQL? I would like to delete, create database and
upgrade with prepared files. I know mysql library but I'm not sure
whether it let me operate on commands such as delete database, source
file_path etc.

I will be appreciated for any help

MT

 

[Ronald Fischer]

I would like to delete, create database and

upgrade with prepared files. I know mysql library but I'm not sure
whether it let me operate on commands such as delete database, source
file_path etc.

If you connect with administrator privileges, you should be able
to execute any command you could also execute from the mysql
command line interface.

Ronald
--=20
Ronald Fischer <[email protected]>
Phone: +49-89-452133-162

 

[Marcin Tyman]

If you connect with administrator privileges, you should be able
to execute any command you could also execute from the mysql
command line interface.

Ronald

dbh.query("source c:/create.sql") - doesn't work. It causes SQL syntax.

 

[Ronald Fischer]

dbh.query("source c:/create.sql") - doesn't work. It causes=20

SQL syntax.

True, but for this case, you can always do

IO.readlines("c:/create.sql").each { |s| dbh.query(s) }

Ronald
--=20
Ronald Fischer <[email protected]>
Phone: +49-89-452133-162

 

[Marcin Tyman]

True, but for this case, you can always do

IO.readlines("c:/create.sql").each { |s| dbh.query(s) }

Ronald

Thanks, I'll check it. It seems to be ok. At the moment I cannot check
it (the db is used)

 

[Ari Brown]

Hi,
How to operate on MySQL? I would like to delete, create database and
upgrade with prepared files. I know mysql library but I'm not sure
whether it let me operate on commands such as delete database, source
file_path etc.

I will be appreciated for any help

You can use Ruby/MySQL, MySQL/Ruby, DBI, or ActiveRecord

~ Ari
English is like a pseudo-random number generator - there are a
bajillion rules to it, but nobody cares.