Cloud9 Ruby DB 변경 하기 (sqlite3 -> mysql )

Cloud9 Ruby, DB 변경 하기 (sqlite3 -> mysql )

1. 기본 Template선택

2. MySQL 설치하기

3. Config변경하기

- 복사본 만들기 : cp config/database.yml config/database.yml.sqlite3

- Gemfile추가하기 : gem 'mysql2' 

- bundle 설치 : bundle install

- config/database.yml 변경하기

4. Database생성하기

> mysql-ctl cli

> create database scaffold2_development;

> create database scaffold2_test;

5. Table 생성하기

- bash 쉘 열기

>rake db:migrate

6. rake db:migrate 오류 발생시 

- Rails Specified 'mysql2' for database adapter, but the gem is not loaded.

https://medium.com/sudogem/rails-specified-mysql2-for-database-adapter-but-the-gem-is-not-loaded-add-gem-mysql2-to-your-gemfile-d35bb40eb961

#gem 'rails', '4.2.5'

#gem 'mysql2', '~> 0.3.20'

* Scaffold 프로젝트 생성하기

>rails g scaffold post title:string content:string

>rake db:migrate

# Run Project

# Preview