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
¸ü¶à>>
Ïà¹ØÎĵµ£º
жÔØmysql
1¡¢²éÕÒÒÔÇ°ÊÇ·ñ×°ÓÐmysql
ÃüÁrpm -qa|grep -i mysql
¿ÉÒÔ¿´µ½mysqlµÄÁ½¸ö°ü£º
mysql-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
2¡¢É¾³ýmysql
ɾ³ýÃüÁrpm -e --nodeps °üÃû
( rpm -ev mysql-4.1.12-3.RHEL4.1 )
3¡¢É¾³ýÀÏ°æ±¾mysqlµÄ¿ª·¢Í·ÎļþºÍ¿â
ÃüÁrm -fr /usr/lib/mysql
r ......
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 ......
Ò»¹²ÓÐÈý¸öÀࣺWriteFile ; ReadFile ; InsertDB ;
//WriteFile.java
//ÓÃÓÚ½«ÐÅϢдÈëÎı¾Îļþ
package org.mb.insertfromfile;
import java.io.*;
public class WriteFile{
private int count = 0 ;
public int getCount() {
return count;
}
public void setCount(int count) {
this.cou ......
ÔÚÉè¼Æ¹ØϵÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØϵģʽRÖеÄÿһ¸ö¾ßÌå¹ØϵrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......
ÓеÄÓû§£¬³öÓÚʹÓÃmysqlÊý¾Ý¿â¿ª·¢ÆäËû³ÌÐòµÄÐèÒª£¬¿ÉÄÜÏ£ÍûÐÞ¸ÄMysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂ룬
ÏÖ×öÒÔϼòҪ˵Ã÷¡£
ÓÉÓÚOAʹÓõÄMysqlÊý¾Ý¿â±»É趨ΪֻÄÜ´Ó±¾»ú·ÃÎÊ£¬ËùÒÔÆÕͨÓû§²»½¨ÒéÐÞ¸ÄÊý¾Ý¿âÃÜÂ룬
ÐÞ¸ÄÊý¾Ý¿âÃÜÂë²¢²»ÊÇΪÁ˸ÄÉÆϵͳ°²È«ÐÔµÄÄ¿µÄ¡£
windows-¡µ¿ªÊ¼—¡µÔËÐУ¬ÊäÈëcmd½øÈëÃüÁîÐÐģʽ£¬²¢Ê¹Ó ......