[Conny Westh]

Ursprungligen postat av Linuus

Skit i rdbi...


1. Installera en gem för mysql. Tex mysql2 (tror den ska vara lite bättre än mysql)
https://github.com/brianmario/mysql2

2. Tuta och kör Finns massa exempel på länken ovan.

Laddade ner mysql2, körde gem install mysql2....

successfully installed....

C:\Projects\Conny\Ruby\MySQL2\mysql2-master>gem install mysql2
Fetching: mysql2-0.3.11-x86-mingw32.gem (100%)

======================================================================================================

  You've installed the binary version of mysql2.
  It was built using MySQL Connector/C version 6.0.2.
  It's recommended to use the exact same version to avoid potential issues.

  At the time of building this gem, the necessary DLL files where available
  in the following download:

  http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

  And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\bin

======================================================================================================

Successfully installed mysql2-0.3.11-x86-mingw32
Parsing documentation for mysql2-0.3.11-x86-mingw32
unable to convert "\x90" from ASCII-8BIT to UTF-8 for lib/mysql2/1.8/mysql2.so, skipping
unable to convert "\x90" from ASCII-8BIT to UTF-8 for lib/mysql2/1.9/mysql2.so, skipping
Installing ri documentation for mysql2-0.3.11-x86-mingw32
1 gem installed

C:\Projects\Conny\Ruby\MySQL2\mysql2-master>

gick till exaples och försökte köra de två exempel som finns där eventmachine.rb respektive threaded.rb, inget av dem funkade.... den skriker på att require cannot load such file.... dvs mysql2

Körde även koden enligt exempel i ReadMe-filen:

# File: mysql2_test.rb
client = Mysql2::Client.new(:host => "localhost", :database => 'test', :username => "root", :password => '**************')
results = client.query("SELECT * FROM players")
results.each do |row|
    puts row
end

Felmeddelande:

C:\Projects\Conny\Ruby\Hello>ruby mysql2_test.rb
mysql2_test.rb:1:in `<main>': uninitialized constant Mysql2 (NameError)

C:\Projects\Conny\Ruby\Hello>

Jag kör senaste version av Ruby dvs 2.0.0p195