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

mysql ibdata1ÎļþµÄËõС

mysql ibdata1ÎļþµÄËõС(2009-12-22 15:29:46)
±êÇ©£ºit 
 
mysql ibdata1´æ·ÅÊý¾Ý£¬Ë÷ÒýµÈ£¬ÊÇMYSQLµÄ×îÖ÷ÒªµÄÊý¾Ý¡£
Èç¹û²»°ÑÊý¾Ý·Ö¿ª´æ·ÅµÄ»°£¬Õâ¸öÎļþµÄ´óСºÜÈÝÒ×¾ÍÉÏÁËG£¬ÉõÖÁ10+G¡£¶ÔÓÚijЩӦÓÃÀ´Ëµ£¬²¢²»ÊÇÌ«ºÏÊÊ¡£Òò´ËÒª°Ñ´ËÎļþËõС¡£
·½·¨£ºÊý¾ÝÎļþµ¥¶À´æ·Å¡£
²½Ö裺
1£¬±¸·ÝÊý¾Ý¿â
´ÓÃüÁîÐнøÈëMySQL Server 5.0\bin
±¸·ÝÈ«²¿Êý¾Ý¿â£¬Ö´ÐÐÃüÁîmysqldump -q -uusername -pyourpassword --add-drop-table -all-databases > /all.sql
×öÍê´Ë²½ºó£¬Í£Ö¹Êý¾Ý¿â·þÎñ¡£
2£¬ÐÞ¸ÄmysqlÅäÖÃÎļþ
ÐÞ¸Ämy.iniÎļþ£¬Ôö¼ÓÏÂÃæÅäÖÃ
innodb_file_per_table
¶ÔÿÕűíʹÓõ¥¶ÀµÄinnoDBÎļþ, ÐÞ¸Ä/etc/my.cnfÎļþ
3£¬É¾³ýÔ­Êý¾ÝÎļþ
ɾ³ýÔ­À´µÄibdata1Îļþ¼°ÈÕÖ¾Îļþib_logfile*£¬É¾³ýdataĿ¼ÏµÄÓ¦ÓÃÊý¾Ý¿âÎļþ¼Ð(mysqlÎļþ¼Ð²»ÒªÉ¾)
4£¬»¹Ô­Êý¾Ý¿â
Æô¶¯Êý¾Ý¿â·þÎñ
´ÓÃüÁîÐнøÈëMySQL Server 5.0\bin
»¹Ô­È«²¿Êý¾Ý¿â£¬Ö´ÐÐÃüÁîmysql -uusername -pyourpassword < /all.sql
¾­¹ýÒÔÉϼ¸²½ºó£¬¿ÉÒÔ¿´µ½ÐµÄibdata1Îļþ¾ÍÖ»Óм¸Ê®MÁË£¬Êý¾Ý¼°Ë÷Òý¶¼±ä³ÉÁËÕë¶Ôµ¥¸ö±íµÄСibdÎļþÁË£¬ËüÃÇÔÚÏàÓ¦Êý¾Ý¿âµÄÎļþ¼ÐÏÂÃæ¡£


Ïà¹ØÎĵµ£º

mysql´æ´¢ÒýÇæÖ® InnoDB

InnoDB¸ÅÊö
InnoDB¸øMySQLÌṩÁ˾ßÓÐÌá½»£¬»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«£¨ACID¼æÈÝ£©´æ´¢ÒýÇæ¡£InnoDBËø¶¨ÔÚÐм¶²¢ÇÒÒ²ÔÚSELECTÓï¾äÌṩһ¸öOracle·ç¸ñÒ»ÖµķÇËø¶¨¶Á¡£ÕâÐ©ÌØÉ«Ôö¼ÓÁ˶àÓû§²¿ÊðºÍÐÔÄÜ¡£Ã»ÓÐÔÚInnoDBÖÐÀ©´óËø¶¨µÄÐèÒª£¬ÒòΪÔÚInnoDBÖÐÐм¶Ëø¶¨ÊʺϷdz£Ð¡µÄ¿Õ¼ä¡£InnoDBÒ²Ö§³ÖFOREIGN KEYÇ¿ÖÆ¡£ÔÚSQL²éÑ¯Ö ......

mysql×Ö·û¼¯²é¿´ÒÔ¼°ÐÞ¸Ä

mysql×Ö·û¼¯²é¿´ÒÔ¼°ÐÞ¸Ä
http://blog.csdn.net/cs870101/archive/2009/09/23/4580879.aspx
ת×Ô:http://blog.chinaunix.net/u2/85344/showart_2042280.html
LiunxÏÂÐÞ¸ÄMySQL×Ö·û¼¯£º
1.²éÕÒMySQLµÄcnfÎļþµÄλÖÃ
find / -iname '*.cnf' -print
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-la ......

ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)

ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)
http://blog.csdn.net/zzuduoduo/archive/2009/05/02/4142504.aspx
°²×°mysql
sudo apt-get install mysql-server #Ö±½Ó×Ô¶¯»ñµÃ¿ÉÓð汾
Ò²¿ÉÒÔÕâÑùд
sudo apt-get install mysql-server-5.0 #°²×°mysql·þÎñÆ÷5.0°æ±¾
°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ ......

MYSQL³£ÓÃÃüÁîÁбí


MYSQL³£ÓÃÃüÁîÁбí
1¡¢ÏµÍ³¹ÜÀí
mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p 
Á¬½ÓMYSQL£¨ÔÚmysql/bin£©
exit 
Í˳öMYSQLÃüÁî
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë 
ÐÞ¸ÄÃÜÂ루ÔÚmysql/bin£©
grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost£¨"%"£¬ ±íʾÈκÎÖ÷»ú£©identifiedby " ......

MySQLѧϰ±Ê¼Ç

mysql·þÎñÆ÷°²×°ÅäÖãº
1. sudp apt-get install mysql-server-5.0
2. ´´½¨¿âsecond_proxy, ΪsecProxyÌí¼ÓÓû§£ºgrant all privileges on second_proxy.* to secProxy@'%' identified by 'passwd';
3. ÉèÖÃmysql.user±íÈçÏ£º
+-----------+------------------+-------------------------------------------+
| Host& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ