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ÎļþÁË£¬ËüÃÇÔÚÏàÓ¦Êý¾Ý¿âµÄÎļþ¼ÐÏÂÃæ¡£
Ïà¹ØÎĵµ£º
1)¡¢È¥sunµÄ¹ÙÍøÏÂÔØÒ»¸ömysqlµÄѹËõ°ü£¬ÎÒÏÂÔØµÄÊÇmysql-noinstall-5.5.0-m2-win32.zip¡£
2)¡¢°ÑÉÏÃæÏÂÔØµÄѹËõ°ü½âѹµ½£ºD:\Program Files\mysqlÏÂÃæ¡£
3)¡¢ÔÚ D:\Program Files\mysql\ ÖÐÕÒ my-large.ini °ÑËü¸´ÖÆ³É my.ini¡£
4)¡¢ÔÚ my.ini ÖÐÕÒ [mysqld] £¬Ìí ......
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) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ ......
(1)µÇ½µ½mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' fo ......
Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔØµÚ¶þ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......