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