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ÎļþÁË£¬ËüÃÇÔÚÏàÓ¦Êý¾Ý¿âµÄÎļþ¼ÐÏÂÃæ¡£
Ïà¹ØÎĵµ£º
ÓÃInstallAnywhere´ò°üJava³ÌÐò°üº¬MySQLÊý¾Ý¿â
InstallAnywhere´ò°üJava³ÌÐòʱ¿ÉÒÔ×Ô¶¯Íê³ÉjreµÄ´ò°ü£¬µ«ÊÇÐèÒªMySQLÊý¾Ý¿âµÄ³ÌÐò¾ÍµÃÊÖ¶¯Ìí¼Ó¡£×ÊÁÏÌ«ÉÙ£¬¾À½áÁËÈýÌ죬ÖÕÓÚ½â¾ö
1¡¢ ÏÂÔØÂÌÉ«°æµÄMySQL£¬¿ÉÒÔÈ¥¹ÙÍøÏÂÔØ¡£ÍøÓÑÖÆ×÷ÁËMySQLµÄÂÌÉ«¾«¼òBat°æ£¨http://download.csdn.net/source/524812 ......
2009-12-08 18:53
sql½Å±¾Êǰüº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆÖ®Îª“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½ ......
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& ......