# Creating new database

**URL:** <https://www.ruby-forum.com/t/creating-new-database/191978>\
**Category:** Rails\
**Created:** [July 21, 2010, 7:00pm UTC](https://www.ruby-forum.com/t/creating-new-database/191978 "2010-07-21T19:00:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 21, 2010, 7:00pm UTC](https://www.ruby-forum.com/t/creating-new-database/191978/1 "2010-07-21T19:00:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 22, 2010, 3:18pm UTC](https://www.ruby-forum.com/t/creating-new-database/191978/2 "2010-07-22T15:18:00Z")

</div>

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

On Jul 21, 12:59 pm, “tashfeen.ekram” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 22, 2010, 3:36pm UTC](https://www.ruby-forum.com/t/creating-new-database/191978/3 "2010-07-22T15:36:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 23, 2010, 2:22am UTC](https://www.ruby-forum.com/t/creating-new-database/191978/4 "2010-07-23T02:22:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 23, 2010, 2:23am UTC](https://www.ruby-forum.com/t/creating-new-database/191978/5 "2010-07-23T02:23:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tashfeen.ekram](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3ab097/32.png) [@tashfeen.ekram](https://www.ruby-forum.com/u/tashfeen.ekram)\
**Post date:** [July 23, 2010, 2:43am UTC](https://www.ruby-forum.com/t/creating-new-database/191978/6 "2010-07-23T02:43:03Z")

</div>

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