# Sqlite specified in database.yml, rails tries to use mysql

**URL:** <https://www.ruby-forum.com/t/sqlite-specified-in-database-yml-rails-tries-to-use-mysql/189670>\
**Category:** Rails\
**Created:** [June 4, 2010, 8:40pm UTC](https://www.ruby-forum.com/t/sqlite-specified-in-database-yml-rails-tries-to-use-mysql/189670 "2010-06-04T20:40:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lpeabody](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/77aa72/32.png) [@lpeabody](https://www.ruby-forum.com/u/lpeabody)\
**Post date:** [June 4, 2010, 8:40pm UTC](https://www.ruby-forum.com/t/sqlite-specified-in-database-yml-rails-tries-to-use-mysql/189670/1 "2010-06-04T20:40:35Z")

</div>

Hi All,

I’ve run into an interesting (and annoying) problem. I have a  
development environment on a Windows machine and on a remote Linux  
machine. I cloned my environment on the Linux machine over to my  
Windows box. I have installed all the required gems for the project.  
When I try to reconfigure database.yml to use sqlite3 instead of mysql,  
and when I try to do a ‘rake db:schema:load’ I get prompted with an  
error box saying:

“The program can’t start because LIBMYSQL.dll is missing from your  
computer. Try reinstalling the program to fix this problem.”

I have no idea why it would even be trying to access a mysql dll if I  
specified that it should be using sqlite3. Any thoughts?

Thanks,  
Les

---

<div class="post-metadata">

**Author:** ![lpeabody](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/77aa72/32.png) [@lpeabody](https://www.ruby-forum.com/u/lpeabody)\
**Post date:** [June 4, 2010, 9:07pm UTC](https://www.ruby-forum.com/t/sqlite-specified-in-database-yml-rails-tries-to-use-mysql/189670/2 "2010-06-04T21:07:36Z")

</div>

Have you checked which environment you are running in ?

Have you removed ALL mysql config from database.yml ?

Trausti

---

<div class="post-metadata">

**Author:** ![lpeabody](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/77aa72/32.png) [@lpeabody](https://www.ruby-forum.com/u/lpeabody)\
**Post date:** [June 4, 2010, 9:10pm UTC](https://www.ruby-forum.com/t/sqlite-specified-in-database-yml-rails-tries-to-use-mysql/189670/3 "2010-06-04T21:10:09Z")

</div>

Trausti Thor J. wrote:

> Have you checked which environment you are running in ?
> 
> Have you removed ALL mysql config from database.yml ?
> 
> Trausti

Solved.

I double checked both of these items, but both were in order. I solved  
the problem by grabbing hold of a libmysql.dll file and dumping it in  
C:\Ruby\bin, and all was well. Windows is so touchy…

Thanks.