Heroku 错误：没有要加载的文件 - sqlite3/sqlite3_native

Question

我在本地机器上使用 Mysql。当我尝试推送数据库时遇到问题。 我已经安装了水龙头。

   Home@PC /c/rails/konkurranceportalen (master)
    $ heroku db:push
    Taps Load Error: no such file to load -- sqlite3/sqlite3_native
    You may need to install or update the taps gem to use db commands.
    On most systems this will be:

    sudo gem install taps

更新后我现在收到以下错误：

Ruby.exe system error
The program could not be started because sqlite3.dll is missing on the computer.

我的数据库 yml：

# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
# gem 'mysql', '2.8.1'

development:
  adapter: mysql
  database: konkurranceportalen
  encoding: utf8
  pool: 5
  username: root
  password: 
  socket: C:/xampp/mysql/bin/mysqld.sock
  host: 127.0.0.1

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.

test:
  adapter: mysql
  database: rails_t
  encoding: utf8
  pool: 5
  username: root
  password: 
  socket: C:/xampp/mysql/bin/mysqld.sock
  host: 127.0.0.1

production:
  adapter: mysql
  database: rails_p
  encoding: utf8
  pool: 5
  username: root
  password: 
  socket: C:/xampp/mysql/bin/mysqld.sock
  host: 127.0.0.1

Answer 1

我确实在这里下载了 sqlite.dll http://www.sqlite.org/download.html
并将其粘贴到 ruby​​/bin 和 myapp/tmp/sockets 中
然后我可以运行 heroku db:push

Answer 2

只需将其添加

gem 'sqlite3'

到“开发”组中的 Gemfile 中即可修复此问题。

Answer 3

您需要先安装 Taps gem。之后它应该会自动工作。

查看您的database.yml 文件是否配置正确。

或者只需使用

$ heroku db:push mysql://root:mypass@localhost/mydb

在上述命令中填写所需的详细信息即可。