Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä´óÈ«

SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓͼ
DROP VIEW --´ÓÊý¾Ý¿âÖÐɾ³ýÊÓͼ ......

¹ØÓÚÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ½â´ð£¨×Ü½áÆª£©

 ¹ØÓÚÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ½â´ð£¨×Ü½áÆª£©
ÕûÀíÁËÒÔÏÂËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨,Ö÷ÒªÊÇÓÐʱºò×Ô¼ºÓöµ½ÁËÕâ¸öÎÊÌâ²»ÖªµÀÔõô¸ãÁË£¬µ±È»Èç¹ûÄܸø¹ã´óµÄPHPer½â¾öÎÊÌâÒ²ÊÇÎÒµÄÈÙÐÒ°¡£¬ºÇºÇ¡£
·½·¨1£º ÓÃSET PASSWORDÃüÁî
¡¡¡¡mysql -u root
¡¡¡¡mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('n ......

½«AccessµÄÄÚÈÝÇ¨ÒÆµ½MySQLÊý¾Ý¿â

Ô­±¾µÄÄ¿µÄÊǽ«Êý¾Ý¿â´ÓMS SQL 2000Ç¨ÒÆµ½MySQLÖУ¬µ«ÌáʾJDBCÁ¬½Óʧ°Ü£¬ÎÞÄÎÖ®¼«£¬Ö»ºÃÑ¡ÔñÖмäÇÅÁºAccessÍê³ÉÕâÏîÁîÈËÌÖÑáµÄ¹¤×÷ÁË¡£
´ó¸Å²½ÖèÈçÏ£º
1£¬´ÓMS SQL 2000½«Êý¾Ýµ¼³öµ½AccessÖУ¬ÓÐ¹Ø±í¶¨ÒåºÃÖ÷¼üºÍ×Ô¶¯±àºÅ²¿·Ö²»È»Ç¨ÒƺóÓÖµÃÐÞ¸ÄMySQLµÄ±í¡£
2£¬ÐÞ¸ÄAccess±íÖйÜÀíÔ±×é¡¢¹ÜÀíÔ±µÄȨÏÞ£¬±£Ö¤AccessµÄÄÚÖà ......

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 Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ