database - Rails Migrate data to mysql workbench GUI -


so trying migrate local database mysql workbench database gui on mac.

in rails app: config/database.yml

default: &default   adapter: mysql   pool: 5   timeout: 5000   username: root   port: 3306 development:   <<: *default   database: db/development.sqlite3 

my guess need change path database. i've changed adapter sqlite3 mysqlbut i'm sure there more configuration needed here...

what necessary steps connect mysql workbench rails application can manage tables?

found needed done.

in database.yml, changed database in development environment generic name demo_development:

default: &default   adapter: mysql   pool: 5   timeout: 5000   username: root   port: 3306 development:   <<: *default   database: demo_development 

dumped existing database in development.sqlite2 ran rake db:create migrated database rake db:migrate , that's it, took @ mysql workbench gui , tables there.

easy ;)


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -