Rake DB迁移MySQL

Question

有人能帮帮我吗？设置一个本地Rails 2.2.2项目，但是rake失败了。mysql gem已安装：

按如下方式安装MySQL gem：

sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
Successfully installed mysql-2.9.0
1 gem installed
Installing ri documentation for mysql-2.9.0...
Installing RDoc documentation for mysql-2.9.0...

然后尝试调用rake：

$ rake --trace db:migrate

**调用db:migrate (first_time)

**调用环境(first_time)

**执行环境

**执行db:migrate

!!！捆绑的mysql.rb驱动程序已从Rails 2.2中删除。

请安装mysql gem，然后重试: gem install mysql。

rake中止！dlopen(/Library/Ruby/Gems/1.8/gems/mysql-2.9.0/lib/mysql/mysql_api.bundle，9)：未加载库: libmysqlclient.18.dylib引用自: /Library/Ruby/Gems/1.8/gems/mysql-2.9.0/lib/mysql/mysql_api.bundle原因:未找到镜像- /Library/Ruby/Gems/1.8/gems/mysql-2.9.0/lib/mysql/mysql_api.bundle

Answer 1

将mysql lib路径添加到.bash_profile和.profile可以修复此问题：

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

Answer 2

在使用rvm ruby1.8.7和Rails2.3的Mavericks上，我必须安装mysql gem

gem install mysql -- --with-mysql-dir=/usr/local/mysql

然后我需要将Slinky答案中的导出添加到我的.zshenv中

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$DYLD_LIBRARY_PATH

Answer 3

问题-！捆绑的mysql.rb驱动程序已从Rails 2.2中删除。请安装mysql gem，然后重试: gem install mysql。rake中止！没有要加载的文件-- mysql/mysql_api

解决步骤-

1) gem安装mysql -with-mysql-dir= Path_to_MySQL_root_folder

2)运行此命令将显示一个下载链接，如下所示- http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

3)将lib/libmysql从该下载文件夹复制到C:/Ruby/bin