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

在一电脑上安装多mysql实例

我的环境:
原有一mysql5.0实例,现新安装一mysql5.1,并将新的5.1实例的数据路径放在另一目录。
mysql5.1的my.ini如下
(配置my.ini的参考资料:
http://dev.mysql.com/doc/refman/5.1/en/option-files.html
http://downloads.mysql.com/docs/mysql-windows-excerpt-5.1-en.pdf
http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html
关键是几个属性:
client组、mysqld组的port要不同;
mysqld组的basedir指示mysql的安装目录;
mysqld组的datadir、innodb_data_home_dir前者是数据的目录,后者是innodb的数据目录,两者必须相同,否则会报错如下:
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100515 20:50:51 [ERROR] Plugin 'InnoDB' init function returned error.
100515 20:50:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100515 20:50:52 [ERROR] Unknown/unsupported table type: INNODB
100515 20:50:52 [ERROR] Aborting;

#------------------------------------------------------------------------------------------------------------
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup o


相关文档:

解决Flex+amfphp+MySQL中文乱码的方法


首先:确定数据库的编码为utf8,正常储存中文(用MySQL-Front查看中文是否正常)
然后:Services查询MySQL时使用"SET NAMES 'utf8'",且通过"amfphp/browser"运行看看是否中文,如果乱码则修改gateway.php文件,去掉 $gateway->setCharsetHandler("utf8_decode", "ISO-8859-1", "ISO-8859-1");
最后:运行Flex程序显 ......

Linux mysql 服务器慢的原因

这几天Linux服务器很慢,很着急找不到解决办法!后百度相关字眼,查找到是MySQL的问题,
如下为解决方案
:
连接MySQL速度慢的解决方法.
PHP远程连接MYSQL速度慢,有时远程连接到MYSQL用时4-20秒不等,本地连接MYSQL正常,出现这种问题的主要原因是,默认安装的
MYSQL开启了DNS的反向解析,在MY.CNF(UNIX或LINUX系统下)或MY.INI ......

Joomla! 建站程序的安装(xampp、apache和Mysql设置)

此处运用了一个集成的xampp架构。不用单独去安装apache服务器,mysql数据库,等等。
(一)Xampp的安装
   下载xampp
1.       双击xampp,点击下一步,下一步,如是,就安装了xampp。(此处安装在了c:\sandbox下面了)
 
2. 进行xampp安装是否成功的测试:
打开:c:\ ......

MYSQL和java中的数值范围 91KGE

mysql数值范围
tinyint  -128~127   0~255
smallint  -32768~32767  0~65535
mediumint -8388608~8388607  0~16777215
int -2147483648~2147483647 0~4294967295
bigint  -9223372036854775808~9223372036854775807   0~18446744073709551615
java中
byte   ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号