Creating new database

1 view
Skip to first unread message

tashfeen.ekram

unread,
Jul 21, 2010, 12:59:05 PM7/21/10
to Ruby on Rails: Talk
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. :)

tashfeen.ekram

unread,
Jul 22, 2010, 9:16:19 AM7/22/10
to Ruby on Rails: Talk
i treid the following and got the same error: rake db:schema:load

On Jul 21, 12:59 pm, "tashfeen.ekram" <tashfeen.ek...@gmail.com>
wrote:

Ajit

unread,
Jul 22, 2010, 9:34:17 AM7/22/10
to Ruby on Rails: Talk
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

tashfeen.ekram

unread,
Jul 22, 2010, 8:20:51 PM7/22/10
to Ruby on Rails: Talk
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.
Message has been deleted

tashfeen.ekram

unread,
Jul 22, 2010, 8:41:16 PM7/22/10
to Ruby on Rails: Talk
I get that error with all commands. rake db:schema:load, rake db:reset
and rake db:migrate:reset

Reply all
Reply to author
Forward
0 new messages