Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlµÄÅäÖÃÎļþmy.ini

# 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 option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to speci


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿âÎļþ½éÉÜ

mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
      ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸ ......

hibernateµ÷ÓÃmysqlÖд洢¹ý³Ì

Ò»£® ½¨±íÓë³õʼ»¯Êý¾Ý
  ÔÚmysqlµÄtestÊý¾Ý¿âÖн¨Á¢Ò»ÕÅÐÂ±í£ºtbl_user,½¨±íÓï¾äÈçÏ£º
  DROP TABLE IF EXISTS `user`;
CREATE TABLE `tbl_user` (
   `userid` varchar(50) NOT NULL,
   `name` varchar(50) default '',
   `blog` varchar(50) default '',
   ......

MysqlÖÐTimestampµÄʹÓÃ

Timestamp·­Òë¹ýÀ´Ò²½Ð“ʱ¼ä´Á”£¬¿ÉÒÔ°üº¬“Äê-ÔÂ-ÈÕ-ʱ-·Ö-Ãë-ºÁÃ딣¬ÊÇjava.util.DateϵÄÒ»¸ö×ÓÀà¡£Èç¹ûÏëʵÏÖÏòMysqlÖвåÈë´øÓÐʱ·ÖÃëµÄʱ¼ä£¬ÔÚ±í½á¹¹ÀïÐèÒªÖ¸¶¨×Ö¶ÎÀàÐÍΪDateTime£¬Java³ÌÐòÀïÔÚ»ñȡϵͳʱ¼äºóÐèҪת»»ÎªÊ±·ÖÃëµÄ¸ñʽ£¬ÔÙת»»ÎªTimestamp¼´¿É£¬ÈçÏÂËùʾ£º
Date dt = new Dat ......

ÈÃMySQLÖ§³ÖInnoDB

ÔÚmysqlÖÐÊäÈëSHOW variables like "have_%"²é¿´£¬ÏÔʾÈçÏ£º
mysql> SHOW variables like "have_%";
  
+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| have_archive     ......

RedHat Enterprise Linux 5ÏÂÅäÖÃApache,Mysql,Php

[¾­¹ý°²×°²âÊԳɹ¦µÄ·½·¨from CYBEND ]
µÚÒ»²½£ºÏµÍ³ÓëÈí¼þµÄ×¼±¸
ϵͳ°æ±¾ redhat enterprise linux 5 ,Äں˰汾 2.6.18
µÚ¶þ²½£ºÈí¼þ°üµÄ×¼±¸
httpdÈí¼þ°ü£ºhttpd-2.2.8.tar.bz2
mysqlÈí¼þ°ü´Ómysql¹Ù·½ÍøÕ¾ÏÂÔØ£¬ÎÒÑ¡ÓõÄÊÇehel5µÄrpm°ü
MySQL-server-community-5.0.51a-0.rhel5.i386.rpm
MySQL-client-community ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ