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

Mysql innodb Îóɾ³ýÊý¾Ý¿âÊÇ·ñ¿É»Ö¸´

¿ÉÒÔ£¬µ«ÊÇÍêÈ«»Ö¸´ËùÓÐµÄ±í²»Ò»¶¨¿ÉÒÔ
¹¤¾ß: innodb-recovery
Official Website: http://code.google.com/p/innodb-tools/
This set of tools could be used to check InnoDB
tablespaces and to recover data from damaged tablespaces or from
dropped/truncated InnoDB tables.
Õâ¸ö¹¤¾ßÓÃÀ´¼ì²éInnoDB¿Õ¼ä±íºÍ»Ö¸´ÓÉÓÚdrop ÒÔ¼°truncateÒý·¢µÄË𻵿ռä±íµÄÊý¾Ý¿âÃÅ
´Ë¹¤¾ßʹÓÃÐèÒª°²×°PerlµÄһЩ²å¼þ£¬ÓÐ:
DBI
Mysql::DBD
»Ö¸´Ç°Ìá,ÌáÁËÒÔÉϵIJå¼þÍ⣬Èç¹ûÔÚʹÓÃʱÓб¨ÉÙ²å¼þ£¬ÔòÐèÒªÕÒµ½ÉٵIJå¼þ£¬ÔÙ°²×°
ÁíÍâ, »Ö¸´Êý¾ÝµÄǰÌáÊÇ£¬Êý¾Ý¿âʹÓõÄÊÇinnodbÒýÇæ£¬µ±ÓÃ'DROP DATABASE DBNAME'ºó£¬Ã»ÓÐÔÙ×öÆäËü²Ù×÷£¬±£Ö¤ibdata1ÎļþµÄÍêÕûÐÔ¼°²»±»ºóÐøÐ´Êý¾ÝÆÆ»µ
Ö´Ðлָ´µÄ¹ý³ÌÖУ¬ÓÐÒ»²½ÊÇÐèҪעÒâµÄ£¬¾ÍÊÇ"Recovery steps: Preparing the code for recovery"
ĬÈÏÉú³ÉµÄ±í½á¹¹ÖеÄһЩÁÐÊôÐԵĸñʽÊDz»¾«È·µÄ£¬ÄãÐèÒª¾«È·ÕâЩÊôÐÔ£¬»Ö¸´µÄ¸ÅÂʲŻáÌá¸ß
######################
Note that this is a translation of the table format into what InnoDB Tools use internally as a C program.
You may need to edit this file later on, to force some constraints on the recovered data.
#####################
µ±Äã°´ÕÕ http://code.google.com/p/innodb-tools/wiki/InnodbRecoverySteps ÀïµÄ²½Öè²Ù×÷Í꣬²¢»Ö¸´Êý¾Ýºó£¬
ÏàÐÅ£¬ ÄãÒÔºóÔÙÒ²²»»á·¶ÀàËÆµÄ´íÎóÁË,ÒòΪÕâ¸ö¹ý³ÌÊÇÂù³¤µÄ£¬µ±È»£¬Ç°ÌáÊÇÄãµÄÊý¾Ý±í¶àÒÔ¼°Êý¾ÝÁ¿´ó¡£


Ïà¹ØÎĵµ£º

ÓÃMySQL Éú³ÉËæ»úÃÜÂë

ÍíÉÏÓÐÅóÓÑÎÊÆð£¬¼òµ¥µÄдÁËÒ»¸ö¡£
DELIMITER $$
CREATE
    FUNCTION `t_girl`
.
`func_rand_string`
(
f_num tinyint
unsigned
,
f_type tinyint
unsigned
)
    RETURNS varchar
(
32)
    BEGIN
       ......

MySQLÐÔÄÜÓÅ»¯

ÔÚApache, PHP, MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½ÓÓ°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´óµÄÒ»¸ö²¿·Ö£¬²»µ«ÐèÒªÀí½âһЩMySQLרҵ֪ʶ£¬Í¬Ê±»¹ÐèÒª³¤Ê±¼äµÄ¹Û²ìͳ¼Æ²¢ÇÒ¸ù¾Ý¾­Ñé½øÐÐÅжϣ¬È»ºóÉèÖúÏÀíµÄ²ÎÊý¡ ......

MySql³£ÓÃÃüÁî

MySQL³£ÓòÙ×÷»ù±¾²Ù×÷£¬ÒÔ϶¼ÊÇMySQL5.0ϲâÊÔͨ¹ýÊ×ÏÈ˵Ã÷Ï£¬¼ÇסÔÚÿ¸öÃüÁî½áÊøÊ±¼ÓÉÏ£»£¨·ÖºÅ£©
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p --default-character-set=latin1 Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû(Êý¾Ý¿âĬÈϱàÂëÊÇlatin1)
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Ó ......

ÕÒµ½MySQLµÄÓŵã

¼ÙÉèÄãÊÇÒ»¸öAccess¿ª·¢ÈËÔ±£¬¶øÄãÏëÒÆÖ²Ò»¸öAccessºǫ́µ½Ò»¸ö±¾µØµÄMySQL ·þÎñÆ÷ÓÃÓÚ¿ª·¢ºÍ²âÊÔ¡£Ä㽫ά»¤Äã×Ô¼ºµÄ½â¾ö·½°¸²¢ÀÖÓÚʹÓÃCommunity Server
¡¡¡¡µÚÒ»²½——°²×°MySQL
¡¡¡¡µ½http://dev.mysql.com/downloads/ ÏÂÔØÕâ¸ö·þÎñÆ÷¡¢MySQL GUI¹¤¾ßºÍMySQL ODBCÇý¶¯¡£Äã¿ÉÒÔÑ¡ÔñµÄ·þÎñÆ÷ÓУº5.0, 5.1»ò6.0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ