MySQLÊý¾Ý¿âÎļþ½éÉÜ
±¾ÎÄÁ´½Óhttp://www.chysoft.net/files/article_234.htm ¸ü¶à×ÊѶÇë½øÈëwww.chysoft.net
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µÄÿ¸öÊý¾Ý¿â¶¼¶ÔÓ¦´æ·ÅÔÚÒ»¸öÓëÊý¾Ý¿âͬÃûµÄÎļþ¼ÐÖÐ(¸ÃĿ¼ÏÂdatadir²ÎÊý¶ÔÓ¦µÄĿ¼ÏÂ)£¬MySQLÊý¾Ý¿âÎļþ°üÀ¨MySQLËù½¨Êý¾Ý¿âÎļþºÍMySQLËùÓô洢ÒýÇæ´´½¨µÄÊý¾Ý¿âÎļþ¡£
MySQLÈç¹ûʹÓÃMyISAM´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢.MYD¡¢.MYI
MySQLÈç¹ûʹÓÃInnoDB´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢ibdata1¡¢.ibd£¬´æ·ÅλÖÃÓÐÁ½¸ö£¬ibdata1¡¢.ibdÎļþĬÈÏ´æ·ÅλÖÃÊÇMySQL°²×°Ä¿Â¼ÏµÄdataÎļþ¼Ð
1¡¢MySQL´´½¨²¢¹ÜÀíµÄÊý¾Ý¿âÎļþ£º
.frmÎļþ£º´æ´¢Êý¾Ý±íµÄ¿ò¼Ü½á¹¹£¬ÎļþÃûÓë±íÃûÏàͬ£¬Ã¿¸ö±í¶ÔÓ¦Ò»¸öͬÃûfrmÎļþ£¬Óë²Ù×÷ϵͳºÍ´æ´¢ÒýÇæÎ޹أ¬¼´²»¹ÜMySQLÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳÉÏ£¬Ê¹ÓúÎÖÖ´æ´¢ÒýÇæ£¬¶¼ÓÐÕâ¸öÎļþ¡£
³ýÁ˱ØÓеÄ.frmÎļþ£¬¸ù¾ÝMySQLËùʹÓõĴ洢ÒýÇæµÄ²»Í¬£¨MySQL³£ÓõÄÁ½¸ö´æ´¢ÒýÇæÊÇMyISAMºÍInnoDB£©£¬´æ´¢ÒýÇæ»á´´½¨¸÷×Ô²»Í¬µÄÊý¾Ý¿âÎļþ¡£
.MYDÎļþ£º¼´MY Data£¬±íÊý¾ÝÎļþ
.MYIÎļþ£º¼´MY Index£¬Ë÷ÒýÎļþ
.logÎļþ£ºÈÕÖ¾Îļþ
2¡¢InnoDB²ÉÓñí¿Õ¼ä£¨tablespace£©À´¹ÜÀíÊý¾Ý£¬´æ´¢±íÊý¾ÝºÍË÷Òý£¬
InnoDBÊý¾Ý¿âÎļþ£¨¼´InnoDBÎļþ¼¯£¬ib-file set£©,¸ÃÎļþÒ»°ã´æÔÚÔÚmysqlµÄÊý¾ÝĿ¼Ï£¬È磺ibdata1¡¢ibdata2µÈϵͳ±í¿Õ¼äÎļþ£¬´æ´¢InnoDBϵͳÐÅÏ¢ºÍÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý£¬ËùÓÐ±í¹²ÓÃ.ibdÎļþ£ºµ¥±í±í¿Õ¼äÎļþ£¬Ã¿¸ö±íʹÓÃÒ»¸ö±í¿Õ¼äÎļþ£¨file per table£©£¬´æ·ÅÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý¡£
3¡¢ÈÕÖ¾Îļþ£º ib_logfile1¡¢ib_logfile2
¸ü¶à>>
Ïà¹ØÎĵµ£º
Ò»£ºasp.netÔõôÁ¬½ÓmysqlÊý¾Ý¿â
ÏÂÔØmysql connectionµÄ¶«Î÷
http://dev.mysql.com/downloads/connector/net/6.2.html
ÓÐ3¸ödownloadÑ¡µÚÒ»¸öÏÂÔØ
Windows (x86, 32-bit), ZIP Archive
mysql-connector-net-6.2.2-noinstall.zip ......
1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
if (myform.user.value=="")
{
alert("ÇëÌîдÓû§");
myform.user.focus();
return f ......
<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 foldmethod=marker: */
//===========================================
// ³ÌÐò£º mysql-Based Session Class
// ¹¦ÄÜ£º »ùÓÚmysql´æ´¢µÄ Session ¹¦ÄÜÀà
// ×÷Õß: yejr
// ÍøÕ¾: http://imysql.cn
// ʱ¼ä: 2007- ......
¸ÃÁ¬½Ó·½Ê½²ÉÓÃRPCÀ´·µ»ØÊý¾Ý¿â²éѯ½á¹û¡£
1.Ê×ÏÈÊÇ´´½¨ÆÕͨµÄGWT-EXT¹¤³Ì¡£¿ÉÒԲο¼1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources
ϵÁÐ Èë ÃÅ ½Ì³Ì¡£¾ßÌåͨѶ¹ý³Ì·þÎñÒ²¿É²Î¿¼ÉÏÊöµÄ×îºó²¿·Ö˵Ã÷¡£
2. ½ÓÏÂÀ´¾ÍÊÇÒª´´½¨GWT Remote ServiceÁË£¬ÔÚÔÓй¤³ÌÉÏnew-&g ......
ÓеÄÓû§£¬³öÓÚʹÓÃmysqlÊý¾Ý¿â¿ª·¢ÆäËû³ÌÐòµÄÐèÒª£¬¿ÉÄÜÏ£ÍûÐÞ¸ÄMysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂ룬
ÏÖ×öÒÔϼòҪ˵Ã÷¡£
ÓÉÓÚOAʹÓõÄMysqlÊý¾Ý¿â±»É趨ΪֻÄÜ´Ó±¾»ú·ÃÎÊ£¬ËùÒÔÆÕͨÓû§²»½¨ÒéÐÞ¸ÄÊý¾Ý¿âÃÜÂ룬
ÐÞ¸ÄÊý¾Ý¿âÃÜÂë²¢²»ÊÇΪÁ˸ÄÉÆÏµÍ³°²È«ÐÔµÄÄ¿µÄ¡£
windows-¡µ¿ªÊ¼—¡µÔËÐУ¬ÊäÈëcmd½øÈëÃüÁîÐÐģʽ£¬²¢Ê¹Ó ......