将WAMP升级到MySQL 5.5? [英] Upgrade WAMP to MySQL 5.5?

问题描述

我的开发团队在php/Mysql环境中使用WAMP，但我刚刚了解到使用MySQL 5.1，而MySQL现在是5.5.我可以将mysql分别升级到5.5，而不会使其与WAMP一起工作吗?或者WAMP是否有补丁程序可以获取最新的mysql?

My dev team uses WAMP for the php/Mysql environment but i just learnt that uses MySQL 5.1 and MySQL is at 5.5 now. Can I get the mysql upgraded to 5.5 separately without any issue to make it work with WAMP or is there any patch for WAMP to get the latest mysql?

我想确保它们可以与最新版本的MySQL一起使用，但是我不确定它是否像下载mySQL 5.5一样简单，并且会自动添加到WAMP服务器中，或者是否兼容?我认为既然WAMP从未更新过他们的MySQL，那么某些东西是不兼容的吗?

I want to ensure they work with the latest build of MySQL but i am not sure if it is as simple as download mySQL 5.5 and it gets auto-added to the WAMP server, or if there are compatible? I assume since WAMP never updated their MySQL something is not compatible?

推荐答案

为您找到了这个

STEP1:(x代表数字)

STEP1: (x represents a number)

下载最新版本的MySQL 首先...复制的新文件夹 mysqlx.x到wamp \ bin \ mysql \检查 mysql和所有数据库的文件夹 文件存在于mysqlx.x \ data文件夹中. 如果mysql文件夹不存在， 从以前的工作复制它 版本的mysql.

Download the latest version of MySQL first... Copy the new folder of mysqlx.x to wamp\bin\mysql\ Check if the folder of mysql and all database files exist in mysqlx.x\data folder. If the mysql folder doesn't exist, copy it from a working previous version of mysql.

检查mysqlx.x \ bin文件夹和所有 其中存在可执行文件.检查是否 文件夹mysqlx.x \ share存在.如果 他们不存在，然后提取 mysql的最新版本不是 做得好.

Check if mysqlx.x\bin folder and all executable files in it exist. Check if the folder mysqlx.x\share exist. If they don't exist, then the extraction of the latest version of mysql isn't done properly.

检查mysqlx.x \ my.ini文件是否存在. 如果不存在，请复制文件 从以前的wakring版本开始 wamp \ bin \ mysql \ mysqlx.x中的wamp mysql 从最新的mysql打开文件 版本，编辑所有出现的 该文件中的"mysqlx.x"到 最新版本为"mysqlx.x" 数字.

Check if mysqlx.x\my.ini file exist. If it doesn't exist, copy the file from the previous wokring version of wamp mysql in wamp\bin\mysql\mysqlx.x Open the file from the latest mysql version, edit all occurrences of "mysqlx.x" in that file to the "mysqlx.x" as the latest version number.

例如，如果您看到该行 "basedir = c:/wamp/bin/mysql/mysql4.1" 在my.ini文件中，然后将其编辑为 "basedir = c:/wamp/bin/mysql/mysqlx.x" 由于mysqlx.x是最新版本 您刚刚下载了.通常在那里 您只需要发生两次 basedir = c:/wamp/bin/mysql/mysqlx.x和 datadir = c:'wamp/bin/mysql/mysqlx.x/data

For example, if you see the line "basedir=c:/wamp/bin/mysql/mysql4.1" in my.ini file, then edit it to "basedir=c:/wamp/bin/mysql/mysqlx.x" as mysqlx.x is the lastest version you've just downloaded. Normally there are only two occurrences you need to edit: basedir=c:/wamp/bin/mysql/mysqlx.x and datadir=c:'wamp/bin/mysql/mysqlx.x/data

STEP2:

将wampserver.conf文件复制到 wamp mysqlx.x的先前版本 wamp \ bin \ mysql \ mysqlx.x的文件夹.你 需要使用记事本打开它，然后 编辑该行: $ mysqlConf ['mysqlExeFile'] = 'mysqld-nt.exe';到 $ mysqlConf ['mysqlExeFile'] = 'mysqld.exe';

Copy the wampserver.conf file in the previous version of wamp mysqlx.x folder to wamp\bin\mysql\mysqlx.x. You would need to open it with notepad and edit the line: $mysqlConf['mysqlExeFile'] = 'mysqld-nt.exe'; to $mysqlConf['mysqlExeFile'] = 'mysqld.exe';

查看mysqlx.x \ bin目录，然后 找出是否有mysqld.exe或 mysql-nt.exe文件.如果没有 mysql-nt.exe文件，然后将其更改

Look at the mysqlx.x\bin directory and find out if there is a mysqld.exe or mysql-nt.exe file. If there is no mysql-nt.exe file, then change that line as mentioned.

STEP3:

关闭wamp2服务器(右侧) 单击湿纸盒图标，然后单击 出口).然后重新启动wamp服务器. 重新启动所有服务.你应该看到 显示的mysql最新版本 wamp mysql菜单.只需点击 最新版本启用它，那么您 运行最新的mysql版本 使用Wamp服务器.

Shutdown the wamp2 server (by right click on wamp tray icon and click exit). Then restart the wamp server. Restart all services. You should see the mysql newest version displayed in wamp mysql menu. Just click on the latest version to enable it, then you have the newest mysql version running with wamp server.

这篇关于将WAMP升级到MySQL 5.5?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！