MySQL´íÎóDLL
MYSQL Õâ¸ö´íÎóÔõô½â¾ö°¡¡£¡£ÇóÖú
Õâ¸ö´íÎó¸ãÎÒµÄDZ̳ÂÛ´ò²»¿ªÇÒIISµ¼³£Ò²²»ÖªÊDz»ÊÇÒòΪËûÒýÆðµÄ
ʼþÀàÐÍ: ´íÎó
ʼþÀ´Ô´: MySQL
ʼþÖÖÀà: ÎÞ
ʼþ ID: 100
ÈÕÆÚ: 2009-12-23
ʼþ: 4:35:36
Óû§: N/A
¼ÆËã»ú: HX110
ÃèÊö:
ʼþ ID ( 100 )µÄÃèÊö(ÔÚ×ÊÔ´( MySQL )ÖÐ)ÎÞ·¨ÕÒµ½¡£±¾µØ¼ÆËã»ú¿ÉÄÜûÓбØÒªµÄ×¢²áÐÅÏ¢»òÏûÏ¢ DLL ÎļþÀ´´ÓÔ¶³Ì¼ÆËã»úÏÔʾÏûÏ¢¡£Äú¿ÉÄÜ¿ÉÒÔʹÓà /AUXSOURCE= ±êʶÀ´¼ìË÷´ÊÃèÊö£»²é¿´°ïÖúºÍÖ§³ÖÒÔÁ˽âÏêϸÐÅÏ¢¡£ÏÂÁÐÐÅÏ¢ÊÇʼþµÄÒ»²¿·Ö: Cannot find or open table video/pv_collectrules from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.
½ö´Ó´íÎóÌáʾÉÏÀ´¿´£¬ÊÇÄãµÄ±íÖеÄibdataÊý¾ÝÎļþÕÒ²»µ½¶ÔÓ¦µÄÄÚÈÝ¡£
µÚÒ»²½£ºÏȼì²éÒ»ÏÂÄãµ
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......