# Migration failure\> mysql gem issues \> xCode install -HELP! **URL:** \ **Category:** Rails\ **Created:** [May 20, 2009, 7:03am UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376 "2009-05-20T07:03:05Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![agilehack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@agilehack](https://www.ruby-forum.com/u/agilehack)\ **Post date:** [May 20, 2009, 7:03am UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376/1 "2009-05-20T07:03:05Z")
please help i am running Mac os x 10.5.7 - have mysql 64 bit installed - ruby 1.8.6 - rails 2.2.2. All ruby and rails functions seemed to be working fine until I tried to do a simple rake db:migrate last night and got errors that seemed to indicate mysql gem needed to be installed (is this true?), I tried to install it and got ruby header errors (amongst others) wich indicated i needed to install xCode (from OS dvd), so i installed that and then was (i think) able to get the mysql gem on but the migrate still throws funky errors: dyld: lazy symbol binding failed: Symbol not found: \_mysql\_init Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/ mysql.bundle Expected in: dynamic lookup and does not work! Now I am not sure where I stand and after much googling it seems many people are going through this and there are various fixes and advice but all of them different. I now have like 9 GB worth of xCode on my system (for a reason I don’t grasp) - may or may not have the mysql gem installed - and still cant migrate. can someone tell me if this situation is common? what the correct fix is? Do I need xCode? How do i uninstall xCode if I don’t? Rails/mySQL/Mac is about as common a marriage there is, so I cant imagine I am alone. pretty sure I can back out the huge xCode install and uninstall the mySQL driver to start over if someone can walk me through the correct resolution. thanks ---
**Author:** ![agilehack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@agilehack](https://www.ruby-forum.com/u/agilehack)\ **Post date:** [May 20, 2009, 8:40am UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376/2 "2009-05-20T08:40:52Z")
hi, did you created the rails project using like rails -d mysql then install gem install mysql… if error comes copy the particular dll from mysql then copy to c:\ruby\bin folder then use rake db:migrate try may be help On 5/20/09, agilehack [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > OS dvd), so i installed that and then was (i think) able to get the > > pretty sure I can back out the huge xCode install and uninstall the > mySQL driver to start over if someone can walk me through the correct > resolution. > > thanks > > > – Velmurugan ---
**Author:** ![agilehack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@agilehack](https://www.ruby-forum.com/u/agilehack)\ **Post date:** [May 20, 2009, 8:59am UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376/3 "2009-05-20T08:59:38Z")
On May 20, 6:02 am, agilehack [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > dyld: lazy symbol binding failed: Symbol not found: \_mysql\_init > Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/ > mysql.bundle > Expected in: dynamic lookup You want the 32bit version of mysql (or at the very least you need to compile the mysql gem against the 32bit version of mysql) since the ruby executable is 32bit and in Mac OS X a 32bit executable cannot load a 64bit library. Fred ---
**Author:** ![agilehack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@agilehack](https://www.ruby-forum.com/u/agilehack)\ **Post date:** [May 20, 2009, 3:56pm UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376/4 "2009-05-20T15:56:43Z")
agilehack wrote: […] > how to uninstall the entire xCode tools package I installed cleanly? If you mean the Developer Tools package, leave it in. It contains C compilers and a bunch of other things you’ll likely need. That goes double if you ever try to install anything through Fink or Macports. ## Best, Marnen Laibow-Koser [http://www.marnen.org](http://www.marnen.org) removed\_email\_address@domain.invalid ---
**Author:** ![agilehack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d2c977/32.png) [@agilehack](https://www.ruby-forum.com/u/agilehack)\ **Post date:** [May 20, 2009, 3:16pm UTC](https://www.ruby-forum.com/t/migration-failure-mysql-gem-issues-xcode-install-help/168376/5 "2009-05-20T15:16:54Z")
ah - that seems to make perfect sense. I shouldn’t have pushed the envelope with the 64 bit mySQL and I knew it at the time. ok so with 32 bit mySQL I should have none of these issues and therefore don’t even need the xCode for ruby header files etc I guess with that in mind, can anyone help me with how to completely uninstall the mySQL version I have now (64 bit) so I can then go get the 32 bit clean and how to uninstall the entire xCode tools package I installed cleanly? thanks for the help guys… live and learn On May 20, 2:58 am, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)