Hi, I want to save to current database to another one with the same format. Does anyone know how to do it ? I have a mysql database to which my Ruby on Rails is connected to. And I want to export a whole table from the current database into another database (with another hostname, another login, another password). Thanks in advance, Greg -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Why re-invent the wheel? For most servers I admin, I use the MySQL Administration Tool. Works real slick. Available from mysql.com/downloads. Works on Linux and Windows. If I need a quick change, I''ll use phpMyAdmin (Google it). PHP based MySQL administration system. Also works really slick. Can you not use these tools? ~k On Wed, 2007-08-01 at 22:35 +0200, Grégory Pardoen wrote:> Hi, > > I want to save to current database to another one with the same format. > Does anyone know how to do it ? > > I have a mysql database to which my Ruby on Rails is connected to. > And I want to export a whole table from the current database into > another database (with another hostname, another login, another > password). > > Thanks in advance, > > Greg-- Kurth Bemis Ozone Computer Consulting, Sales and Service 1 Main Street Springfield, VT 05156 802-885-8030 888-321-OZONE ozonecomputer.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Yes, of course I can do that but this not the goal of the web application that I''m building ! But thanks anyway for the answer ! The end user doesn''t know phpmyadmin, and should not learn it. So what I want, it''s to make an automatic save of a table into an another database. The real goal of this kind of backup is that the current database is local to the computer and the automatic save should make a copy of a local table into another database. And this last database is online, and can be view from internet. Thanks in advance, Greg Kurth Bemis wrote:> Why re-invent the wheel? > > For most servers I admin, I use the MySQL Administration Tool. Works > real slick. Available from mysql.com/downloads. Works on Linux and > Windows. > > If I need a quick change, I''ll use phpMyAdmin (Google it). PHP based > MySQL administration system. Also works really slick. > > Can you not use these tools? > ~k > > On Wed, 2007-08-01 at 22:35 +0200, Gr�gory Pardoen wrote: >> Thanks in advance, >> >> Greg > -- > Kurth Bemis > Ozone Computer > Consulting, Sales and Service > > 1 Main Street > Springfield, VT 05156 > > 802-885-8030 > 888-321-OZONE > ozonecomputer.com-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
This might be part of what you''re looking for: http://magicmodels.rubyforge.org/magic_multi_connections/ Grégory Pardoen wrote:> Hi, > > I want to save to current database to another one with the same format. > Does anyone know how to do it ? > > I have a mysql database to which my Ruby on Rails is connected to. > And I want to export a whole table from the current database into > another database (with another hostname, another login, another > password). > > Thanks in advance, > > Greg-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thanks, I think this can work. Steve Koppelman wrote:> This might be part of what you''re looking for: > > http://magicmodels.rubyforge.org/magic_multi_connections/ > > Grégory Pardoen wrote: >> Hi, >> >> I want to save to current database to another one with the same format. >> Does anyone know how to do it ? >> >> I have a mysql database to which my Ruby on Rails is connected to. >> And I want to export a whole table from the current database into >> another database (with another hostname, another login, another >> password). >> >> Thanks in advance, >> >> Greg-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---