<div>
<div>
<span>I'm not sure, my impression is that it's supposed to be a drop-in replacement.</span></div><div><span><br></span></div><div><span>But it's quick to try. Just install the gem, and set the adapter to mysql2 in database.yml. If ActiveRecord works, you're good :)</span></div><div><span><br></span></div><div><span>But also, do make sure your settings are correct in database.yml too, cause it looks like it's complaining about some charset config mismatch.</span></div><div><span><br></span></div><div><span><br></span></div><div><span>-jim<br>
</span>
<span><br><div><br></div></span>
<p style="color: #a0a0a0;">On Monday, January 17, 2011 at 13:31, Adrian Stainforth wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div>Thanks, but I believe that only works with rails3, doesn't it? I'm trying to get it to work with rails 2.3.8 for old sites.<br><br><div class="gmail_quote">On 17 January 2011 13:23, Jim Myhrberg <span dir="ltr"><<a href="mailto:contact@jimeh.me">contact@jimeh.me</a>></span> wrote:<br><blockquote type="cite"><div><div>
<div>
<span>I'm not sure what version of Rails you're using, but with the latest version of Rails uses the mysql2 gem, which is faster and better in every possible way from what I've read. Also, it installs and compiles perfectly fine on OSX.</span></div>
<div><span><br></span></div><div><span>Check the GitHub repo for more info:</span></div><div><span><a href="https://github.com/brianmario/mysql2" target="_blank">https://github.com/brianmario/mysql2</a></span></div><div>
<span><br>
</span></div><div><span><br></span></div><div><span><a href="https://github.com/brianmario/mysql2" target="_blank"></a>-jim<br>
</span><div><div class="h5">
<span><br><div><br></div><div><br></div></span>
<p style="color:#a0a0a0">On Monday, January 17, 2011 at 13:05, Adrian Stainforth wrote:</p>
</div></div><blockquote type="cite"><div>
<span><div><div><div class="h5"><div>Can anyone help me, I'm struggling with an RVM install with mysql.<div><br></div><div>I'm on Mac OSX 10.6 64bit and have installed rvm fine with 1.8.7 and rails 2.3.8 and then installed mysql server which is also 64bit.</div>
<div><br></div><div>I then tried to install the mysql gem using:</div><div><br></div><div><div>env ARCHFLAGS="-arch x86_64" rvm gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config</div></div>
<div><br></div><div>but then once I run rake db:setup or db:migrate I get the following error: </div><div><br></div><div><div>** Invoke db:setup (first_time)</div><div>** Invoke db:create (first_time)</div><div>** Invoke db:load_config (first_time)</div>
<div>** Invoke rails_env (first_time)</div><div>** Execute rails_env</div><div>** Execute db:load_config</div><div>** Execute db:create</div><div>Couldn't create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"tabascopizza_development", "pool"=>5, "password"=>nil}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation)</div>
<div>** Invoke db:schema:load (first_time)</div><div>** Invoke environment (first_time)</div><div>** Execute environment</div><div>** Execute db:schema:load</div><div>-- create_table("enters", {:force=>true})</div>
<div>rake aborted!</div><div>uninitialized constant MysqlCompat::MysqlRes</div><div><br></div><div>I've tried googling and most of them go on about making sure mysql and ruby are 64bit which they are because I check with 'which ruby' & 'which mysql'</div>
<div><br></div><div>Does anyone have any ideas on why it is failing?</div><div><br></div><div>Thanks</div><div><br></div>-- <br>Kind Regards<br>Adrian Stainforth<br><br>Front-end Developer<br><br>
</div>
</div></div></div><div>_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br><a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</div></div></span>
</div></blockquote><div>
<br>
</div>
</div>
</div><br>_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
<br></div></blockquote></div><br><br clear="all"><br>-- <br>Kind Regards<br>Adrian Stainforth<br><br>Front-end Developer<br>Mobile: +447740069109<br><br>
</div><div>_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br><a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br></div></div></span>
</blockquote>
<div>
<br>
</div>
</div>
</div>