mysql 修改字段类型 production_使用MySQL在Production环境

修改配置文件Gemfile

group :development do

gem 'sqlite3'

end

group :production do

gem 'mysql2'

end

安装软件包

$ sudo apt-get install libmysql-ruby libmysqlclient-dev

安装依赖包

$ bundle install

修改配置文件config/database.yml

production:

adapter: mysql2

encoding: utf8

reconnect: false

database: log_analysis_test

pool: 5

username: log_user

password: "123456"

host: localhost

迁移production环境数据库

$ rake db:drop RAILS_ENV=production

$ rake db:create RAILS_ENV=production

$ rake db:migrate RAILS_ENV=production

$ rake db:seed RAILS_ENV=production

编译production环境静态文件

修改配置文件config/environments/production.rb

config.serve_static_assets = false --> config.serve_static_assets = true

编译完成后，文件会生成在public/asserts/

$ rake assets:precompile

启动production环境服务器

$ rails server -e production