What is the mysql equivalent to heroku pg:reset DATABASE?

[braini...@gmail.com]

Hey Everyone,

I was just wondering if anyone knew the mysql equivalent to $ heroku pg:reset DATABASE.

Thank you

[Walter Lee Davis]

You can use rake db:reset in your Rails root, with the correct RAILS_ENV= set in the same line. Your database user (as configured in the database.yml file) will have to have the authority to drop the database.

Walter

> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/80629938-6c4d-435e-8e3a-ea0077a8dad0%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[braini...@gmail.com]

Thank you Walter. What if I am performing the task from a command line?

[Walter Lee Davis]

That is the command-line:

cd /path/to/your/app
rake db:reset RAILS_ENV=production (or whatever)

That will do the whole job. It will drop the database, re-create it, and build up all the tables from the schema.rb.

Walter

> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/face91e8-6313-41f7-9209-09db2bd9652c%40googlegroups.com.

[David Merrick]

Do what Walter said

[David Merrick]

in terms of Rails the two are interchangeable.

On Sun, 24 Feb 2019 12:18 PM <braini...@gmail.com> wrote: