易截截图软件、单文件、免安装、纯绿色、仅160KB

Windows下MySQL重装引起问题的解决

解决了Plugin 'InnoDB' init function returned error问题和error1405那个安全设置密码登陆问题,我个人觉得关键点在于删除C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\目录下的数据文件,当然,我不可能在重现问题求证了,不过看此贴的人可以尝试一下只做此步是否能解决问题,当然还有删除MYSQL安装目录中的残留文件步骤也比较重要
Cite from:http://forums.mysql.com/read.php?22,144428,250105#msg-250105
Re: Plugin 'InnoDB' init function returned error.
Posted by: Richard Lee ()
Date: February 27, 2009 10:21AM
For Windows OS: 
OK, I struggled with this for ages. There are various partial fixes that did not fix it for me on the web, but in the end the following worked: 
If you've installed it, then uninstall (an earlier version that had been removed could have left crap that is causing an issue, so best to start off clean). Do this as follows: 
- Add/Remove Programs and remove MySQL. 
- Delete the Programs File/MySQL folder (it gets left behind) 
- Delete the data file (where ever you stored it) #:\MySQL DataFiles > This is assuming you have no data to as yet to worry about!!!! 
- Run RegEdit and delete all the MySQL Keys (search and F3) and the half a dozen or so CLSIDs that coe up with just a single non-defailt key for MySQL. You can leave ADOBE\ keys that mention it if you have dreamweaver etc. As allways back up you registry first before choppig it! 
OK. Now run te install and go through the config wizard until it fails at the start up. Then close it. 
Now open up Services and open MySQL properties - I set it to run under the Administrator account rather than System/ANOther to ensure it had permissions. 
Next, go to your new MySQL DataFile and delete 'ibdata1'. 
Then go to 'C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data' and delete all tje 'ib_logfile' prefixed files (should be 0 and 1) - useful to notice the .err log here to which is a text file


相关文档:

PHP/MYSQL实现按字母检索

方法一:建一个拼音表 t_cosler ,存放每个字母开头的第一个汉字的编号和最后一个汉字的编号。   
BatchFile code+------+--------+-------+  
| f_PY | cBegin | cEnd  |  
+------+--------+-------+  
| A    |  45217 | 45252 | & ......

设置MySQL数据同步(单向&双向)

设置MySQL数据同步(单向&双向)
由于公司的业务需求,需要网通和电信的数据同步,就做了个MySQL的双向同步,记下过程,以后用得到再翻出来,也贴出来供大家参考。
一、准备服务器
由于MySQL不同版本之间的(二进制日志)binlog格式可能会不一样,因此最好的搭配组合是Master的MySQL版本和Slave的版本相同或者更低,Ma ......

MySQL数据库引擎介绍

如果你是个赛车手,并且按一下按钮就能够立即更换引擎而不需要把车开到车库里去换,那会是什么感觉呢?MySQL数据库为开发人员所做的就好像是按按钮换
引擎;它让你选择数据库引擎,并给你一条简单的途径来切换它。
MySQL的自带引擎肯定是够用了,但是在有些情况下,其他的引擎可能要比手头所用更适合完成任务。如果愿意的 ......

Hibernate + MYSQL结合存储 Blob 和 Clob内容

      今天,折腾了一个下午,终于解决了Hibernate 存储Blob字段时,数据量非常大时总是报 can not update jdbc batch的错误了,原来是MySQL中没有设定最大允许值所致,我还以为是Hibernate操作不符合标准才这样。。。呵呵,在Mysql 5.1中的my.ini配置文件中加入如下设置:
[MYSQL]
max_allowed ......

linux下mysql编译安装方法备忘

# tar -zxvf mysql-5.0.45.tar.gz -C /usr/src/
# cd /usr/src/mysql-5.0.45
# ./configure --prefix=/usr/local/mysql --with-charset=gbk
--localstatedir=/usr/local/mysql/data
# make
# make install
# groupadd mysql
# useradd mysql -g mysql
# cd /usr/local/mysql/bin
# ./mysql_install_db --user=mys ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号