I have a development db for my app and wanted to create a new development db. so, i created a new and changed the config files as needed. one but i can not do any new migrations. i tried rake db:reset and rake db:migrate:reset however it gives me the error that a certain table is not found. I can create the db with rake db:create. Do I need to somehow reset the schema? Sorry, but this is a newbie question. :) -- 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.
i treid the following and got the same error: rake db:schema:load On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I have a development db for my app and wanted to create a new > development db. so, i created a new and changed the config files as > needed. one but i can not do any new migrations. i tried rake db:reset > and rake db:migrate:reset however it gives me the error that a certain > table is not found. I can create the db with rake db:create. Do I need > to somehow reset the schema? Sorry, but this is a newbie question. :)-- 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.
Please try following one more time: goto you database.yml and change your development database name to "appname_new_development" then from console.. rake db:create and rake db:migrate let me know if it helped. Ajit On Jul 22, 9:16 am, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> i treid the following and got the same error: rake db:schema:load > > On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > > > I have a development db for my app and wanted to create a new > > development db. so, i created a new and changed the config files as > > needed. one but i can not do any new migrations. i tried rake db:reset > > and rake db:migrate:reset however it gives me the error that a certain > > table is not found. I can create the db with rake db:create. Do I need > > to somehow reset the schema? Sorry, but this is a newbie question. :)-- 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.
tried that it sitll gives me the same error. :( te@ubuntu:/var/www/khorasan$ rake db:create (in /var/www/khorasan) te@ubuntu:/var/www/khorasan$ rake db:migrate (in /var/www/khorasan) rake aborted! Mysql::Error: Table ''myapp_dev.users'' doesn''t exist: SHOW FIELDS FROM `users` (See full trace by running task with --trace) te@ubuntu:/var/www/khorasan$ users is a table in my prior dev table. On Jul 22, 9:34 am, Ajit <ajitscor...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Please try following one more time: > > goto you database.yml and change your development database name to > "appname_new_development" > > then from console.. > > rake db:create > > and rake db:migrate > > let me know if it helped. > > Ajit > > On Jul 22, 9:16 am, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > i treid the following and got the same error: rake db:schema:load > > > On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > wrote: > > > > I have a development db for my app and wanted to create a new > > > development db. so, i created a new and changed the config files as > > > needed. one but i can not do any new migrations. i tried rake db:reset > > > and rake db:migrate:reset however it gives me the error that a certain > > > table is not found. I can create the db with rake db:create. Do I need > > > to somehow reset the schema? Sorry, but this is a newbie question. :)-- 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.
unfortunately, it seesm like i get the same error. :( te@ubuntu:/var/www/khorasan$ rake db:create (in /var/www/khorasan) te@ubuntu:/var/www/khorasan$ rake db:migrate (in /var/www/khorasan) rake aborted! Mysql::Error: Table ''myapp_dev.users'' doesn''t exist: SHOW FIELDS FROM `users` (See full trace by running task with --trace) te@ubuntu:/var/www/khorasan$ users is a table in original dev table. On Jul 22, 9:34 am, Ajit <ajitscor...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Please try following one more time: > > goto you database.yml and change your development database name to > "appname_new_development" > > then from console.. > > rake db:create > > and rake db:migrate > > let me know if it helped. > > Ajit > > On Jul 22, 9:16 am, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > i treid the following and got the same error: rake db:schema:load > > > On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > wrote: > > > > I have a development db for my app and wanted to create a new > > > development db. so, i created a new and changed the config files as > > > needed. one but i can not do any new migrations. i tried rake db:reset > > > and rake db:migrate:reset however it gives me the error that a certain > > > table is not found. I can create the db with rake db:create. Do I need > > > to somehow reset the schema? Sorry, but this is a newbie question. :)-- 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.
I get that error with all commands. rake db:schema:load, rake db:reset and rake db:migrate:reset On Jul 22, 8:20 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> tried that it sitll gives me the same error. :( > > te@ubuntu:/var/www/khorasan$ rake db:create > (in /var/www/khorasan) > te@ubuntu:/var/www/khorasan$ rake db:migrate > (in /var/www/khorasan) > rake aborted! > Mysql::Error: Table ''myapp_dev.users'' doesn''t exist: SHOW FIELDS FROM > `users` > > (See full trace by running task with --trace) > te@ubuntu:/var/www/khorasan$ > > users is a table in my prior dev table. > > On Jul 22, 9:34 am, Ajit <ajitscor...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Please try following one more time: > > > goto you database.yml and change your development database name to > > "appname_new_development" > > > then from console.. > > > rake db:create > > > and rake db:migrate > > > let me know if it helped. > > > Ajit > > > On Jul 22, 9:16 am, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > i treid the following and got the same error: rake db:schema:load > > > > On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > > wrote: > > > > > I have a development db for my app and wanted to create a new > > > > development db. so, i created a new and changed the config files as > > > > needed. one but i can not do any new migrations. i tried rake db:reset > > > > and rake db:migrate:reset however it gives me the error that a certain > > > > table is not found. I can create the db with rake db:create. Do I need > > > > to somehow reset the schema? Sorry, but this is a newbie question. :)-- 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.