Creating new database

rubyonrails-talk
1

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:

2

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

3

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

4

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.

5

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