Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±¸·ÝÓë»Ö¸´

mysql server4.0.18
Åú´¦ÀíÎļþÃûΪdbBackup.bat
ÄÚÈÝ£ºrem ÅжÏmysql·þÎñÊÇ·ñÆô¶¯£¬È»ºó½«²éѯ½á¹ûÊä³öµ½server.logÎļþÀï
netstat -na | (find "0.0.0.0:3306" & find "LISTENING")>server.log
rem ÊÖ¹¤½¨Á¢Ò»¸ö¿ÕµÄÎļþtemp.log£¬ÎªÁ˺Íserver.logÎļþÏà±È½Ï
rem ½«server.logÓëtemp.logÏà±È½Ï£¬Èç¹ûmysql·þ ......

MySQL 5.1ÍêÈ«Ð¶ÔØ

ÓÉÓÚ°²×°MySQLµÄʱºò£¬ÊèºöûÓÐÑ¡Ôñµ×²ã±àÂ뷽ʽ£¬²ÉÓÃĬÈϵÄASCIIµÄ±àÂë¸ñʽ£¬ÓÚÊǽӶþÁ¬ÈýµÄÖÐÎÄת»»ÎÊÌâËæÖ®¶øÀ´£¬¾ÍÏëÐ¶ÔØÁËÖØÐ°²×°MYSQL£¬ÕâÒ»Ð¶ÔØµ¹ÊdzöÁËÎÊÌ⣬µ¼Ö°²×°µÄʱºò°²×°²»ÉÏ£¬ÔÚÍøÉÏÕÒÁËÒ»¸ö¶àСʱҲû½â¾ö¡£
ÖØ×°ÏµÍ³ÓÀÔ¶ÊǸöºÃ°ì·¨£¬µ«ÓÐ˭ϲ»¶Õâô×öѽ:(
ºóÀ´ÎÞÒâ·¢ÏÖÊÇÐ¶ÔØµÄʱºòûÓÐÐ¶ÔØÍêÈ«µ¼Ö£ ......

UbuntuÖÐ Mysql Ô¶³ÌµÇ¼µÄ½â¾ö·½·¨

mysql>use mysql;
mysql>update user set host='%' where user='root';
ÖØÆôMysql
sudo /etc/init.d/mysql restart
[sudo] password for wangzw:
*Stopping MySQL database server mysqld                   & ......

MYSQLÍü¼ÇROOTÃÜÂëºó£¿

 
 MYSQLÍü¼ÇROOTÃÜÂëºó£¿
 
ÐÞ¸ÄMySQLµÄµÇ¼ÉèÖãº
1.È¡ÏûȨÏÞ¹ÜÀí
±à¼­ /mysql5.1/my.ini
ÔÚ[mysqld]µÄ¶ÎÖмÓÉÏÒ»¾ä£ºskip-grant-tables
ÀýÈ磺
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
skip-grant-tables
Ä¿µÄÊÇΪÁË£º
Ìø¹ýMySQLµÄ·ÃÎ ......

ÕÒµ½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ºÅ