Creating new database

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. :slight_smile:

i treid the following and got the same error: rake db:schema:load

On Jul 21, 12:59 pm, “tashfeen.ekram” [email protected]

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

tried that it sitll gives me the same error. :frowning:

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.

unfortunately, it seesm like i get the same error. :frowning:

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.

I get that error with all commands. rake db:schema:load, rake db:reset
and rake db:migrate:reset