本文介绍了Rails,如何将数据从开发 sqlite3 数据库迁移到生产 MySQL 数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

With Rails, how do you migrate data from development sqlite3 database to production MySQL database?

How to make it easier?

解决方案

You should use a gem like YamlDB. Install the Gem and then use the following rake tasks

rake db:data:dump
RAILS_ENV=production rake db:data:load

The first command dumps the contents of dev database to a file called db/data.yml

Also, please remember that this must be used in addition to rake db:schema:dump|load tasks as this only ports the data assuming the schema is already in place

这篇关于Rails,如何将数据从开发 sqlite3 数据库迁移到生产 MySQL 数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-16 11:55
查看更多