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 ÀïµÄ²½Öè²Ù×÷Í꣬²¢»Ö¸´Êý¾Ýºó£¬
ÏàÐÅ£¬ ÄãÒÔºóÔÙÒ²²»»á·¶ÀàËÆµÄ´íÎóÁË,ÒòΪÕâ¸ö¹ý³ÌÊÇÂù³¤µÄ£¬µ±È»£¬Ç°ÌáÊÇÄãµÄÊý¾Ý±í¶àÒÔ¼°Êý¾ÝÁ¿´ó¡£
Ïà¹ØÎĵµ£º
¡¾51CTO.com¶À¼ÒÌØ¸å¡¿Ãæ¶Ô¾ª»ÅµÄ¿Í»§ºÍ¹ã·ºÖÊÒɵÄýÌ壬Oracle¹Ù·½×î½üÖÕÓÚ³ö°ñ°²Ãñ£¬ÄDZãÊÇÒ»¸öÒÔ“SUN CUSTOMERS ,Oracle Plans To£º”Ϊ´ó±êÌâµÄ¹ã¸æ¡£Ö±Òë¹ýÀ´±ã¹ýÀ´¿ÉÖªµÀ£¬Oracle½«Òª¼Ó´óSPARCºÍSolarisµÄͶÈëÁË£¬¶ø´óÀϰ尣ÀïÉÒ²ÏòIBMÓ²¼þÏÂÁËÕ½Ê飬Éù³ÆOracle½«×îÖÕÓ®µÃÕⳡ¾ºÕù……
&n ......
ÍíÉÏÓÐÅóÓÑÎÊÆð£¬¼òµ¥µÄдÁËÒ»¸ö¡£
DELIMITER $$
CREATE
FUNCTION `t_girl`
.
`func_rand_string`
(
f_num tinyint
unsigned
,
f_type tinyint
unsigned
)
RETURNS varchar
(
32)
BEGIN
......
#!/usr/bin/perl
use Mysql;
print "Content-type:
text/html \n\n";
# MySQL
ÅäÖñäÁ¿
$host = "localhost";
$database
= "testdb";
$tablename = "testtable";
$user = "username";
$pw =
"password";
# PERL MYSQL CONNECT()
$connect = ......
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 Reference Manual for version 4.1.0-alpha.
¡¡ÒëÕßÐò
¡¡ÁÐÀàÐÍÓ뺯ÊýË÷Òý
6 MySQL ÓïÑԲο¼
6.1 ÓïÑԽṹ
6.1.1 ÎÄ×Ö£ºÔõôд×Ö·û´®ÓëÊý×Ö
6.1.1.1 ×Ö·û´®
6.1.1.2 Êý×Ö
6.1.1.3 Ê®Áù½øÖÆÖµ
......