Hi, I am creating such an application in which there is multipal servers. Now there is parent server which has multipal child server . My original data is in parent server''s database. My problem is I want to dump all the data from parent database to child database. How would i do this? My database is MySql 5.0 -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Jun 25, 2011, at 2:37 AM, News Aanad wrote:> Hi, > I am creating such an application in which there is multipal servers. > Now there is parent server which has multipal child server . My > original data is in parent server''s database. > My problem is I want to dump all the data from parent database to > child database. > How would i do this? > > My database is MySql 5.0Have a read in the MySQL manual about Master / Slave replication. You (or your DBA) can set up this relationship in a few "clicks", and then the two databases will become identical and stay that way. Walter -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
This link ought to help you quite a bit, as it did for me when I had to set up replication servers: http://dev.mysql.com/doc/refman/5.0/en/replication.html Good luck. On Jun 25, 2:37 am, News Aanad <news.anan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > I am creating such an application in which there is multipal servers. > Now there is parent server which has multipal child server . My original > data is in parent server''s database. > My problem is I want to dump all the data from parent database to child > database. > How would i do this? > > My database is MySql 5.0-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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.